When configuring your database for use with your LRS, you should determine what type of Create, Read, Update, and Delete (CRUD) access privileges users will need.
What are CRUD privileges?
CRUD stands for Create, Read, Update, and Delete. Different users may have different CRUD privileges based on their roles. An LRS editor, for instance, may have the ability to create a new LRS, in addition to read, update, and delete records in the LRS tables. Conversely, you may want LRS editors to only be able to create, read, and update records in the network feature class and minimum schema feature classes and tables, such as centerline and calibration points. Event editors may be given privileges to create, update, and delete records in event feature classes only; alternately, they could be given more wide-ranging privileges allowing for editing networks and minimum schema items. To configure privileges in your database, see Configuring user permissions for editing LRS Networks.
What are the typical CRUD privileges for Roads and Highways items in the database?
When configuring access privileges for the database with Roads and Highways feature classes and tables, you should determine what types of editing roles exist in your organization. Based on those roles, you can determine which access privileges are given to users in each role. The table below shows a typical Roads and Highways configuration of access privileges for four different roles. These roles include an LRS Owner, LRS Editor, Event Editor, and Event Viewer. The LRS Owner has the ability to both configure and change specific settings for the LRS (such as dominance rules for the network) and also edit LRS Networks, events, and minimum schema items. The LRS Editor has the ability to perform route updates, but not edit events or change LRS configurations. Event Editors have the ability to edit events, but not LRS Networks or LRS configurations. Event viewers have the ability to view LRS Networks and events, but not make any edits or other changes.
| LRS Owner | LRS Editor | Event Editor | Event Viewer | Versioned | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
LRS Feature Class/Table | C | R | U | D | C | R | U | D | C | R | U | D | C | R | U | D | x |
Calibration Point | x | x | x | x | x | x | x | x | x | x | x | ||||||
Centerline | x | x | x | x | x | x | x | x | x | x | x | ||||||
Centerline Sequence | x | x | x | x | x | x | x | x | x | x | x | ||||||
Intersection feature class | x | x | x | x | x | x | x | x | x | x | x | ||||||
LRS Edit Log | x | x | x | x | x | x | x | ||||||||||
LRS Event Behavior | x | x | x | x | x | ||||||||||||
LRS Locks | x | x | x | x | x | x | x | x | x | x | x | x | x | ||||
LRS Metadata | x | x | x | x | x | x | x | ||||||||||
Network feature class | x | x | x | x | x | x | x | x | x | % | x | x | |||||
Event feature class | x | x | x | x | x | x | x | x | x | x | x | x | x | x | |||
Redline | x | x | x | x | x | x | x | x | x | x | x | x | x | x | |||
% = Access given if feature access is enabled on Event Editor map service