topic Re: Permissions in SQL Server in Data Management Questions

Permissions in SQL Server

TimHayes — Wed, 08 Mar 2017 01:44:05 GMT

I am using Database Authentication. There are multiple users in our SQL Server 2008 R2 Enterprise Geodatabase using ArcGIS 10.2.2. What would be the recommended permissions if I wanted to do the following:

- One user can create/change geodatabase feature class schemas, create/edit data/feature classes.

- The other users cannot make changes to the schema, but can only create/edit data/feature classes.

I need to have my sysadmin set these in SQL Server Management Studio, not ArcGIS.

Re: Permissions in SQL Server

Asrujit_SenGupta — Wed, 08 Mar 2017 04:47:03 GMT

The owner (user creating the objects) of the database objects (tables, feature classes,..) will always have the permissions to change its Schema, delete it, grant other users access to that object, etc.

Changing the schema of existing data is one of those things that only the Data Owner can perform.

Re: Permissions in SQL Server

AdamZiegler1 — Wed, 08 Mar 2017 13:35:06 GMT

Hi Tim - Here is a help link that lays out the different enterprise geodatabase activities and require privileges to accomplish them.

Privileges for geodatabases in SQL Server—Help | ArcGIS Desktop

-Adam Z