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