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.