Mastering ArcGIS Enterprise Administration

Dbo schema

To create an enterprise geodatabase with a dbo schema, you will configure and execute the Create Enterprise Geodatabase tool as shown in the following screenshot:

Our sa database admin user is a member of sysadmin, and we didn't specify to use an SDE owned schema. We end up with the following setup:

• Our enterprise geodatabase is owned by the dbo user. An account specifically for owning data can also be created.
• A dbo schema for our database, meaning all SDE system tables, will be prefixed with dbo.
• Any user who is a member of the sysadmin fixed server role can create data such as feature classes, feature datasets, or tables, in ...