Granting privileges to NIS components through ArcCatalog

Since the NIS XML was imported into the geodatabase, you need to assign permissions in the new NIS workspace to the editor and viewer database roles.

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 editor and viewer database roles for the Nautical feature dataset, all feature classes, and all tables.

Role	Privileges
RLNISEDITOR	Select, Insert, Update, Delete
RLNISVIEWER	Select

1. In the Catalog window, click the Toggle Contents Panel button at the top.

   The Toggle Contents Panel dialog box appears.

2. Select the Nautical feature dataset, right-click, then click Manage > Privileges.

   The Privileges dialog box appears.

3. Click Add.
4. Type RLNISEDITOR in the User/Role text box.
5. Click OK.
6. Click Add.
7. Type RLNISVIEWER in the User/Role text box.
8. Click OK.
9. Check the Select, Insert, Update, and Delete check boxes for RLNISEDITOR.
10. Check the Select check box for RLNISVIEWER.

    The privileges should look something like the following.

    

11. Click OK.
12. Select every table stored in the NIS with the exception of the following:
    • Nautical feature dataset
    • ClosingLinesL
    • PLTS_NAUTICAL_DELETES_A
    • PLTS_NAUTICAL_DELETES_L
    • PLTS_NAUTICAL_DELETES_P

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

    The Change Privileges dialog box appears.

14. Type RLNISEDITOR in the User text box.
15. Click the View (Select) (optional) drop-down arrow and choose GRANT.
16. Click the Edit (Update/Insert/Delete) (optional) drop-down arrow and choose GRANT.
17. Click OK.
18. Right-click the selected tables and click Manage > Privileges.

    The Change Privileges dialog box appears.

19. Type RLNISVIEWER in the User text box.
20. Click the View (Select) (optional) drop-down arrow and choose GRANT.
21. Click OK.
22. Select the following feature classes stored in the NIS:
    • ClosingLinesL
    • PLTS_NAUTICAL_DELETES_A
    • PLTS_NAUTICAL_DELETES_L
    • PLTS_NAUTICAL_DELETES_P

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

    The Change Privileges dialog box appears.

24. Type RLNISEDITOR in the User text box.
25. Click the View (Select) (optional) drop-down arrow and choose GRANT.
26. Click the Edit (Update/Insert/Delete) (optional) drop-down arrow and choose GRANT.
27. Click OK.
28. Right-click the selected feature classes and click Manage > Privileges.

    The Change Privileges dialog box appears.

29. Type RLNISVIEWER in the User text box.
30. Click the View (Select) (optional) drop-down arrow and choose GRANT.
31. Click OK.
32. Close ArcMap.