Configuring user permissions for editing LRS Networks

As a database administrator, you can create users and roles within a database. You can organize database users into roles or groups, which allow you to define permissions and functionality accessible to the group.

The ALRS Owner is responsible for creating the ALRS geodatabase, centerline feature class, calibration point feature class, centerline sequence, routes, and redlines. Using Esri Roads and Highways, the ALRS Owner would also create the ALRS Network and route layers, and register event layers.

The ALRS Editor is responsible for performing edits on the ALRS Network using the Roads and Highways editing tools. The ALRS Editor is restricted from creating or deleting feature classes or object classes in the table space owned by the ALRS Owner. The ALRS Editor cannot change the schema of existing feature classes and object classes.

For more information about ways for administrators to group users, see User accounts and groups.

Once users have been granted write permissions on the relational database management system (RDBMS), they can perform the following tasks:

• Network editing workflows.
• Have event behaviors applied for Oracle and SQL Server users (who are not the same users that own the schema for the LRS).
• Register events as a user other than the owner of the Oracle or SQL Server LRS tables.

Note:

The steps in this task are for database administrators (DBAs) or ALRS Owners who are responsible for maintaining the ALRS geodatabase.

In this topic, you learn how to do the following:

• Create users and roles
• Grant edit permissions

Creating users and roles

Common categories or groups of ArcSDE users are those who view data, edit data, and create data. The specific types of privileges needed for these groups are detailed in the user permission topics for each DBMS. Read the one that applies to the DBMS you use.

• Privileges for geodatabases in Oracle
• Privileges for geodatabases in SQL Server

Granting edit permissions

1. Start ArcCatalog.
2. If you do not have ArcToolbox open, click the Show/Hide ArcToolbox button on the Standard toolbar to show ArcToolbox.
3. Expand the Data Management Tools toolbox.
4. Expand the Geodatabase Administration toolset.
5. Double-click the Change Privileges geoprocessing tool.

   

   The Change Privileges geoprocessing dialog box appears.

   

6. Next to the Input Dataset field, click the browse button.
7. Navigate to the location of the RDBMS and choose the following ALRS Core components:
   • CalibrationPoint
   • Centerline
   • CenterlineSequence
   • Redline
   • Route

   Press the Shift or Ctrl key to make multiple selections.

   

8. In the same RDBMS, press Shift and choose all ALRS system tables.

   The ALRS system tables include the LRS_METADATA, LRS_EVENT_BEHAVIOR, and LRS_EDIT_LOG tables.

9. Click Add.
10. In the User field, type the name of the role for which you want to grant Edit permissions.
11. On the View drop-down menu, select GRANT.
12. On the Edit drop-down menu, select GRANT.

    

13. Click OK.

    Once the geoprocessing tool executes, all users in the role now have edit permissions in the LRS Network.

    Note:

    You may want to restrict modification of LRS configuration properties, such as the gap calibration method for the LRS Network for some users. To restrict a user from modifying the LRS configuration properties, provide only View (Select) access to the LRS_EVENT_BEHAVIOR and the LRS_METADATA tables.