yangliu2209

SDE_SCHEMA GEODATABASE VS DBO_SCHEMA GEODATABASE

Discussion created by yangliu2209 on Nov 27, 2013
Latest reply on Nov 28, 2013 by crafty762
Hi All,

I do a lot of research on sde user and dbo user; however, I am still confused. I am a geospatial database administrator. We have SQL SERVER 2008R2 and ArcGIS 10.1. I don't think we run ArcSDE post installation Wizard now. We usually create a geodatabase by "Create an Enterprise Geodatabase" tool. So, I have to give some of GIS people 'sa' account password and 'sde' account password so that they can create their own enterprise geodatabase. I don't want to do this. My idea is create two different login accounts for two different department in sql server. These two login accounts are mapped to dbcreator role only in order to create database. And then GIS people can add user to their own database; finally enable database to enterprise geodatabase using "Enable Enterprise Geodatabase" tool. This process a dbo geodatabase. My question are: What are they different and when should I use dbo user when should I use sde user? Do they will influence version? Thanks!

Best,
-YL

Outcomes