Available with Production Mapping license.
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 using the following statement in the appropriate SQL command window:
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 |
Creating database connection files
Create database connection files for the following users.
- SDE—This connection file manages all geodatabase administration tasks.
- PRODLIB—This is the product library owner connection file with full privileges.
- PL Edit Users—Connection files for product library editors. They will have permission to do check in and check out and edit the existing product nodes.
For the convenience of all other users, these connection files may be moved to a central location where they can be accessed.
For more information, see Database connections in ArcGIS for Desktop.