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!