Configuring user permissions for editing LRS Networks

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

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

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

Learn more about ways for administrators to group users

Once write permissions are granted on the relational database management system (RDBMS), the following actions can be performed:

• Network editing workflows.
• Apply event behaviors as a user other than a data owner or LRS owner.
• Register event layers with the LRS as a user other than the LRS owner.

Note:

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

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

• Create users and roles
• Grant edit permissions

Creating users and roles

Enterprise geodatabase users are grouped into database roles that control who can view, edit, and create data. The best practice is to grant privileges to roles and force users to inherit privileges from these common roles instead of directly granting privileges to users. The privileges that must be granted vary by RDBMS and can be found below:

• 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 file geodatabase or enterprise geodatabase connection file and choose the following LRS Core components:
   • CalibrationPoint
   • Centerline
   • CenterlineSequence
   • Redline
   • Network

   Press the Shift or Ctrl key to make multiple selections.

   

8. In the same geodatabase, press Shift and choose all LRS system tables.

   The LRS 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.