User name and schema question

648
6
Jump to solution
03-28-2014 02:09 PM
Highlighted
Regular Contributor
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?
Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
Regular Contributor III
Tim,

Yes,  your approach is correct.

View solution in original post

Reply
0 Kudos
6 Replies
Highlighted
Esri Esteemed Contributor
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
Reply
0 Kudos
Highlighted
Regular Contributor
I realize that. Sorry I was not clear. I should have added an underscore. Can you help me?
Reply
0 Kudos
Highlighted
Esri Esteemed Contributor
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
Reply
0 Kudos
Highlighted
Regular Contributor
Whaaaat?SDO schema?I wonder if I was just hit by a car and don't know it yet.  This is twilight zone stuff.
Reply
0 Kudos
Highlighted
Esri Esteemed Contributor
Dbo schema.  Can't you just pretend I don't have dysnomia. 😕
Reply
0 Kudos
Highlighted
Regular Contributor III
Tim,

Yes,  your approach is correct.

View solution in original post

Reply
0 Kudos