Creating geodatabase user roles (Production Mapping)

A role needs to be assigned to the users that 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 using the following statement in the appropriate SQL command window:

Note:

Copying and pasting the example may cause syntax errors.

USE [prodlibdb]
GO
EXEC sp_droprole 'ckb_users'
GO
EXEC sp_addrole 'ckb_users', 'prodlib'
GO

User names for the role are required for anyone who will 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 and already have this privilege.

For product library editors, the following is suggested:

User type	Role
Data editor/Data viewer	CKB_USERS

Editor role