AnsweredAssumed Answered

Permissions in SQL Server

Question asked by Wolseley on Mar 7, 2017
Latest reply on Mar 8, 2017 by AZiegler-esristaff

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. 

Outcomes