When creating an ArcGIS Enterprise Geodatabase using the SDE schema in Microsoft SQL Server, should the SDE user be assigned db_owner?

ifnotthisthanthat

When you are in the process of creating an enterprise geodatabase using the SDE schema, are you supposed to assign the SDE user the db_owner role?

@LeoDonahue states: "If you choose to go with a sde schema, the sde user will never and should not load data into the geodatabase.  All of your ArcSDE related tables will be prefixed with "sde."  But you are free to create other SQL Server accounts with the correct permissions to perform the role of data loading"

Therefore, because sde is created to solely create the enterprise geodatabase, should the db_owner be assigned to a trusted user?

This article states: "The sde user must be added to the db_owner role in the database to upgrade. Alternatively, the upgrade can be run by a user (other than sde) who is in the db_owner database role or sysadmin fixed server role".

Is it good practice to use sde to set up the enterprise geodatabase and then assign users privileges?

Thanks!

George_Thompson

I would not assign db_owner to the SDE (geodatabase admin) user, except when upgrading (as you noted above).

After the enterprise GDB is created, I create data owners and load data / assign permissions / etc. via that user.