topic Re: Making a User a DBO in Data Management Questions

Making a User a DBO

StevenGraf1 — Tue, 09 Sep 2014 20:29:21 GMT

I'm trying to figure out how to make a user a dbo in our enterprise geodatabase (SQL Server 2008 Express) and I am having issues...

According to ESRI Docs: In the case of dbo users, a dbo schema is present in all databases by default; any login that is dbo in the database will store data in the dbo schema.

Maybe I'm not mapping the user to db_owner right, but if I add them to the db_owner role and schema, shouldn't the user add data to the enterprise geodatabase as the dbo instead of their user schema. Ex: instead of MyDB."steven".MyData shouldn't it be MyDB.DBO.MyData if I mapped the user to the db_owner role and schema? Or does the user always inherit their own schema when they add data? Or is the dbo always the sysadmin?

Thanks in advance!

Re: Making a User a DBO

AaronCohen — Tue, 09 Sep 2014 20:44:43 GMT

Start reading here: User privileges for geodatabases in SQL Server

ArcGIS Help (10.2, 10.2.1, and 10.2.2)

Re: Making a User a DBO

StevenGraf1 — Tue, 09 Sep 2014 20:52:04 GMT

I understand all of that. Those are permissions inside ArcCatalog. In this situation, multiple people will be loading data into the geodatabase (windows authentication). They will need to be able to apply permissions to the data within that geodatabase but you can only apply permissions on data that you own. That's why I was wondering if you made a couple users the dbo, shouldn't the users be able to apply permissions to each others data?

Re: Making a User a DBO

StevenGraf1 — Tue, 09 Sep 2014 21:17:22 GMT

I found what I need in this post.

Thanks for the reply!

Re: Making a User a DBO

JoeBorgione — Tue, 09 Sep 2014 23:14:24 GMT

Proceed with caution. Maybe I'm old enough to be old school: for all the years I've been working in databases, spatial and more traditional, dbo is a sacred right. Too many can/will be too many... Just sayin...