Granting privileges to nautical components through ArcCatalog

Since the nautical product library XML was imported into the geodatabase, you need to assign permissions in the new nautical 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.

Grant the following privileges to the CKB_USERS database role.

Objects	Role	Privileges
PL_Permission (and PLTS_UCE* tables, if you have them in your schema)	CKB_USERS	Select
All other tables except PL_Permission (and PLTS_UCE* tables, if you have them in your schema)	CKB_USERS	Select, Insert, Update, Delete

1. Start ArcMap.
2. Click the Toggle Contents Panel button at the top of the Catalog window.

   The Toggle Contents Panel dialog box appears.

3. In the Toggle Contents Panel dialog box, select the PL_Permission table and the PLTS_UCE* tables, right-click, then click Manage > Privileges.

   The Change Privileges dialog box appears.

4. Type CKB_USERS in the User text box.
5. Click the View (Select) (optional) drop-down arrow and choose GRANT.
6. Leave the Edit (Update/Insert/Delete) (optional) field blank.
7. Click OK.

   The Toggle Contents Panel dialog box appears.

8. Select every table stored in the product library with the exception of the following:
   • PL_PERMISSION
   • PLTS_UCE_CONVERSIONS
   • PLTS_UCE_MAPPINGS
   • PLTS_UCE_ROUNDINGRULES

9. Right-click the selected tables and click Manage > Privileges.

   The Change Privileges dialog box appears.

10. Type CKB_USERS in the User text box.
11. Click the View (Select) (optional) drop-down arrow and choose GRANT.
12. Click the Edit (Update/Insert/Delete) (optional) drop-down arrow and choose GRANT.
13. Click OK.
14. Select the following feature classes stored in the product library:
    • PL_CHART_AOI
    • PL_ENC_AOI
    • PL_NIS_AOI

15. Right-click the selected feature classes and click Manage > Privileges.

    The Change Privileges dialog box appears.

16. Type CKB_USERS in the User text box.
17. Click the View (Select) (optional) drop-down arrow and choose GRANT.
18. Click the Edit (Update/Insert/Delete) (optional) drop-down arrow and choose GRANT.
19. Click OK.
20. Close ArcMap.