AnsweredAssumed Answered

DBO or SDE or what schema?

Question asked by Wolseley on Mar 29, 2014
Latest reply on Oct 21, 2014 by mbly29
I am using ArcGIS 10.2.1 with SQL Server 2008 R2 OS Authentication.

To create a SQL Server Enterprise Geodatabase is it a requirement to use DBO or SDE Schema? can I create my own schema based on a user group name? for example, I have 3 users each with a different user name. I want all 3 to be db_owner. I can do this at the database level in SQL Server Management Studio. But, the ArcGIS documentation says the user name and schema must be the same name. If I am using DBO schema then my user name must be DBO. This is how I read it. Will it work if I create a user group named, for example: GIS_People; which contains the user names of 3 users; then create a schema named GIS_People; Or must I use only the DBO or SDE schema?

The ArcGIS requirement for the user name and schema name to be the same is really confusing the heck out of me. Other non-ArcGIS databases I am using in SQL Server, the user name and schema name can be different and there are no problems.

Outcomes