ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

Creating geodatabase user roles

Available with Production Mapping license.

  • Creating database connection files

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:

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 typeRole

Data editor/Data viewer

CKB_USERS

Editor role

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.

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2020 Esri. | Privacy | Legal