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.

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

ALRS Editor is someone 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 Editing cannot change the schema of existing feature classes and object classes.

For more information about ways for administrators to group users, see User groups or roles.

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 who 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 will 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, those who edit data, and those who create data. The specific types of privileges needed for these groups are detailed in the user permission topics for each DMBS. Read the one that applies to the DBMS you use:

• User permissions for geodatabases in Oracle
• User permissions for geodatabases in SQL Server

Granting edit permissions

Steps:

1. Start ArcCatalog.
2. Click ArcToolbox window .

   The ArcToolbox dialog box appears with a list of geoprocessing tools.

3. Expand the Data Management Tools toolbox.
4. Expand the Database toolset.
5. Double-click the Change Privileges geoprocessing tool.

   The Change Privileges geoprocessing dialog box appears.

6. Next to the Input Dataset field, click browse .
7. Navigate to the location of the RDMBS 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 RDMBS, press SHIFT and choose all ALRS system tables.

   ALRS system tables have the prefix LRS.

9. In the same RDMBS, press SHIFT and choose all staging tables.

   Staging tables have the prefix LRST.

10. Click Add.
11. In the User field, enter the name of the role that you want to grant edit permissions.
12. On the View drop-down menu, select GRANT.
13. On the Edit drop-down menu, select GRANT.
14. Click OK.

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