Users, roles, and privileges

Within the geodatabase, there is a hierarchy of users, with each level being based on what actions the user can perform. We have talked at length about the most powerful two of these users, the database administrator and geodatabase administrator. These users are vital to the creation, management, and maintenance of the enterprise geodatabase. As the following diagram shows, with great power, there must also come great responsibility. Database administrators and geodatabase administrators are both powerful accounts with far-reaching privileges. The following diagram shows that with increased privileges in the database, come increased responsibilities:

Note

Remember that the geodatabase administrator account should never own data in the geodatabase.

The data owner account

Another important account is the data owner; this account owns the schema and therefore the data, sets privileges, performs maintenance tasks, and probably most importantly, loads data into the geodatabase...