Creating geodatabase user roles in Oracle (Production Mapping)

A role needs to be assigned to the users who are going to be working with the product library so they can view or add components, information, and data to the product library. These permissions are at the geodatabase level, assigned separately from the product library permissions. The role CKB_USERS must be created for the users to be recognized by the product library. This can be done using the following statement.

NoteNote:

Copying and pasting the example may cause syntax errors.

CREATE ROLE CKB_USERS NOT IDENTIFIED

User names for the role are required for any users who are going to be working with the product library and need to read from or write to the product library tables and other components. The administrators are considered the owners of the data, so they already have this privilege.

For product library editors, the following is suggested:

User type

Role

Oracle permissions

Data editor

  • CONNECT
  • CKB_USERS

CREATE SESSION

Editor role

Related Topics

6/8/2015