[GIS] Why can’t a user with db_owner role version data

arccatalogarcgis-serverenterprise-geodatabaseversioning

I've made an enterprise geodatabase and added a user with db_owner permissions.

When I add a database connection in ArcCatalog and connect to this geodatabase using the user I created, I'm not able to version the data.

When I right click on a table or dataset in the enterprise geodatabase in ArcCatalog the menu is all grayed out except for the "Locks…" selection.

I've added the user to other enterprise geodatabases with the same permissions and everything worked fine. The user was able to version data.

What could be wrong here?

If I sign into the geodatabase that isn't working with the SDE login, I am able to version the data.

Best Answer

Only the data owner is be able to version the data (ie if you loaded the data with SDE, then only SDE can version the data). The reason for this is that when you register something as versioned, it is not a trivial operation. Database objects need to be created.

More information about verioning is available in the Esri help doc What is a version?.

Related Solutions

[GIS] ArcGIS Server 10 and SQL Server 2008 R2 permissions and feature services

link to connection string parameters
Not sure how to get this into arccatalog dialog though.
Users and Roles Overview

[GIS] n’t data be loaded into enterprise geodatabase logged in with sde user

The ArcSDE administrative user (sdeuser) account is responsible for the administration of the following:

ArcSDE geodatabase system tables, triggers, and procedures

The ArcSDE service

Versions

The ArcSDE administrator owns all the ArcSDE geodatabase system files, directories, and tables. For this reason, the ArcSDE administrative account must be created before the geodatabase can be created. The database administrator (DBA) creates the ArcSDE administrator and grants this user the necessary permissions. On Windows installations, this can be accomplished through the Post Installation wizard. On UNIX/Linux, this is done manually, and how it is done depends on the operating system and database management system (DBMS) you are using.

All other users must be GRANTED Permissions on their accounts to load/change/delete data.

Key to this is:

It is recommended that the ArcSDE administrator and its schema only be used to manage and store ArcSDE system tables. You should create separate user schemas in which to store your ArcSDE data objects such as feature classes and raster datasets. You should not store these objects in the ArcSDE administrator’s storage space, since you could possibly crash the ArcSDE service by filling up the ArcSDE administrator’s space

Full Documentation: http://webhelp.esri.com/arcgisserver/9.3/java/index.htm#geodatabases/user_pe-564470524.htm

Best Answer

Related Solutions

[GIS] ArcGIS Server 10 and SQL Server 2008 R2 permissions and feature services

[GIS] n’t data be loaded into enterprise geodatabase logged in with sde user

Related Question