User name and schema question

[TimHayes]

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?

[VinceAngelo]

Having spaces in user names is almost as bad as having a period.  It will mangle your
resultant tables past recognition.  Underscores okay, spaces bad.

- V

[TimHayes]

I realize that. Sorry I was not clear. I should have added an underscore. Can you help me?

[VinceAngelo]

I don't think I can. It's been years since I last had to set up a SQL-Server instance,
and I've never done so using a SDO DBO schema or with Windows authentication.

- V

[LeoDonahue]

Whaaaat?SDO schema?I wonder if I was just hit by a car and don't know it yet.  This is twilight zone stuff.

[VinceAngelo]

Dbo schema.  Can't you just pretend I don't have dysnomia. 😕

[AsrujitSengupta · Accepted solution]

Tim,

Yes,  your approach is correct.