AnsweredAssumed Answered

User name and schema question

Question asked by Wolseley on Mar 28, 2014
Latest reply on Mar 30, 2014 by asengupta-esristaff
I am using ArcGIS 10.2.1 with SQL Server 2008 R2 with Windows Authentication.

I have an existing SQL Server Instance within which are several databases. I want to set up my Enterprise SQL Server Geodatabase and have no access to the other databases which are not for geodatabases. For my database I need 1 user to be able to create, delete, edit, and update new and existing data (administer the database and feature classes); I need another user to be able to delete, edit, update, existing data (feature classes).

The user name and schema must be the same. Can I setup the user name and schema like this:

For the Database Administrator-
User name = Mister X

Schema = Mister X

For the Database Editor-
User name = Mister Y

Schema = Mister Y

Or what is the best approach here?