The administrative user for database servers

Geodatabases stored on database servers (instances of Microsoft SQL Server Express) have two types of administrative users: server administrators and geodatabase administrators.

The server administrator

The server administrator is a database administrator (DBA) and an ArcSDE administrator rolled into one. This user can add other users to the database server, control user permissions, create and delete geodatabases, detach and attach databases, and back up and restore databases. In addition, this user can perform ArcSDE administrative tasks in the geodatabase, such as compressing the geodatabase.

Server administrators are part of the sysadmin fixed server role in the SQL Server Express instance. All members of this role are considered dbo users. In the geodatabase, that means all data owned by server administrators are owned by dbo and stored in a schema named dbo. Because the server administrator creates the geodatabases on the database server, this user owns the database and the ArcSDE geodatabase system tables in the database.

The geodatabase administrator

The other type of administrative user—a geodatabase administrator—is a Windows-authenticated user assigned to the geodatabase database owner role (db_owner) in the SQL Server Express instance. This user can perform administrative tasks, such as administering other users' geodatabase permissions, making a backup of the geodatabase, and compressing the geodatabase. Geodatabase administrators cannot administer the database server or other geodatabases for which they have not been given administrator privileges.

For more information on how users are added and permissions are administered on database servers, see Adding users or groups to a database server and A quick tour of permissions for database servers .

Related Topics

4/22/2015