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.