AnsweredAssumed Answered

Making a User a DBO

Question asked by steven_3535 on Sep 9, 2014
Latest reply on Sep 9, 2014 by jborgion

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!

Outcomes