Permissions in SQL Server

[TimHayes]

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. 

[Asrujit_SenGupta · Accepted solution]

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.

[AdamZiegler1]

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