Granting privileges to product library components through ArcCatalog

Read/Write privileges are already assigned to all the product library tables, except the PL_PERMISSION which doesn't need them. This is done when the product library is defined or upgraded. If a product library XML was imported into a geodatabase, or distributed, you need to re-create the CKB_USERS role and assign permissions in the new product library geodatabase.

The PL_PERMISSION table only needs read privileges assigned to it.

Both the administrator and other user accounts in the underlying database management system should have appropriate privileges and roles assigned to them. When you set up your connection to your spatial database, ensure that you are connecting as the appropriate user.

1. Start ArcCatalog.
2. Expand Database Connections in the Catalog Tree window.
3. Double-click the product library administrator connection geodatabase to connect to it.
4. Select all tables except PCAT_PERMISSION, right-click, then click Manage > Privileges.
5. Type CKB_USERS into the User text box on the Change Privileges dialog box.
6. Click the View (Select) drop-down arrow and choose GRANT.
7. Click the Edit (Update/Insert/Delete) drop-down arrow and choose GRANT.
8. Click OK.
9. Select the PCAT_PERMISSION table, right-click, then click Privileges.
10. If the CKB_USERS role is not already in the list, do the following:
    1. Click Add.

       The User/Role dialog box appears.

    2. If the role is listed, check the check box next to the name.
    3. If the role is not listed, type CKB_USERS in the User/Role text box.
    4. Click OK.
11. Click the Select drop-down arrow and choose GRANT.
12. Click OK.