Privileges for using ArcGIS with Dameng

Privileges determine what a user is authorized to do with the data and the database. Assign privileges based on the type of work the person does within the organization.

Users connecting to Dameng from ArcGIS require system access and access to specific user data. As a Dameng administrator, you create groups based on what users need to do in the database, grant privileges to the groups, and add the appropriate database users to each group.

The following table lists three groups of users and the minimum privileges they require to query, edit, or create data from ArcGIS.

Type of userRequired privilegesPurpose

Data viewer


This privilege allows users to connect to the database.

  • SELECT on sysgeo.geometry_columns
  • SELECT on sysgeo.spatial_ref_sys

Data viewers need access to these system tables to see spatial data.

SELECT on other users' tables

Data viewers need access to specific tables you want them to see and query.

Data editor*

Data editors require the same privileges as data viewers, plus these additional privileges.

INSERT, UPDATE, DELETE on other users' tables

Grant the editing operations you want editors to perform on specific tables.

You can grant any combination of INSERT, UPDATE, and DELETE privileges depending on what editors need to do. Therefore, you can create multiple editor groups and grant the appropriate privileges to each. For example, you can have a full_edit group that has all three privileges plus SELECT on the tables group members need to edit and an updates_only group that has only SELECT and UPDATE privileges on the tables members need to edit.

Data creator

Data creators require the same privileges as data viewers, plus these additional privileges.

  • INSERT, UPDATE, DELETE on sysgeo.geometry_columns and sysgeo.spatial_ref_sys

These privileges allow data creators to create tables and feature classes in the database and populate ObjectID fields.

*To edit data, publish editable web feature layers that reference the data in the Dameng database.