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.

  • What data are you trying to Version? Only the data owner should be able to version the data (ie if you loaded the data with SDE, then only SDE can version the data).
    – travis
    Apr 18 '13 at 0:32
  • Really? So whatever user loads the data into the geodatabase. That user is the only one who can version the data? In this case I loaded the data logged in as SDE. I then created a new user in the geodatabase with db_owner permissions and they could not version the data. I figured if I made the user a db_owner they would be able to version it.
    – ianbroad
    Apr 18 '13 at 0:56
  • Is there any way around this? Also, is this in their documentation? I haven't been able to find it anywhere.
    – ianbroad
    Apr 18 '13 at 0:57
  • Ya, registering a dataset as versioned is not a trivial operation. There are a number database objects that need to be created. If you are interested in what is going on behind the scenes, you can read up on it at resources.arcgis.com/en/help/main/10.1/index.html#/….
    – travis
    Apr 18 '13 at 1:05
  • There isn't a way around this that I know of. You may want to look at your workflow and see why you are creating data as the SDE user in the first place. Usually, you don't want to do that. Also, why someone other than the data owner would need to be able to version a feature class.
    – travis
    Apr 18 '13 at 1:09

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?.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.