topic Re: User name and schema question in Data Management Questions

User name and schema question

TimHayes — Fri, 28 Mar 2014 21:09:34 GMT

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?

Re: User name and schema question

VinceAngelo — Fri, 28 Mar 2014 23:00:30 GMT

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

Re: User name and schema question

TimHayes — Fri, 28 Mar 2014 23:06:43 GMT

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

Re: User name and schema question

VinceAngelo — Fri, 28 Mar 2014 23:21:37 GMT

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

Re: User name and schema question

LeoDonahue — Sat, 29 Mar 2014 00:59:07 GMT

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

Re: User name and schema question

VinceAngelo — Sat, 29 Mar 2014 02:30:19 GMT

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

Re: User name and schema question

AsrujitSengupta — Mon, 31 Mar 2014 04:58:39 GMT

Tim,

Yes, your approach is correct.