topic Re: Privileges, Register as Version commands are greyed out when right-clicking a feature class in an ArcSDE geodatabase in ArcGIS Enterprise Questions

Privileges, Register as Version commands are greyed out when right-clicking a feature class in an ArcSDE geodatabase

AhmadSALEH1 — Fri, 23 Mar 2018 20:42:11 GMT

When right-clicking a feature class in an ArcSDE geodatabase from ArcGIS Desktop, the 'Privileges', ‘Register As Version’ commands are grayed out even though the user is connected as the data owner, and (Advanced) ArcGIS Desktop license is being used.

In my case the data owner is the ‘SDE’ user, I restored this database from the backup to a new SQL server instance on a test machine, The SDE user is able to connect to the database and view the feature classes, now I am trying to assign privileges to users and register the feature classes as versioned and I found out that the Privileges, Register as Version commands are grayed out!

I made sure that I am using the SDE user who owns the data and an Advanced license of ArcMAP 10.5.0 https://support.esri.com/en/technical-article/000009946

I tried to use change privileges (data management) tool but I got this error!

ERROR 999999: Error executing function.

DBMS table not found [42000:[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Cannot find the object 'CanLocations_evw', because it does not exist or you do not have permission.]

Failed to execute (ChangePrivileges).

I checked the view in the database in its there!

What might be the issue here!

Thanks in advance

Ahmad

Re: Privileges, Register as Version commands are greyed out when right-clicking a feature class in an ArcSDE geodatabase

Asrujit_SenGupta — Sun, 25 Mar 2018 04:21:58 GMT

You might have granted the SYSADMIN server role to the SDE login, which will make it a DBO schema user and thus those options will be grayed out.

Just as a quick test, you can try creating a simple table or a feature class, connected as the SDE login and check the Data Owner schema.

Did you resync the SDE login after restore of the database?

How To: Re-synch SQL Server logins or users after restoring a database from backup

Re: Privileges, Register as Version commands are greyed out when right-clicking a feature class in an ArcSDE geodatabase

VinceAngelo — Mon, 26 Mar 2018 01:47:52 GMT

Cross-posted to GIS StackExchange

Re: Privileges, Register as Version commands are greyed out when right-clicking a feature class in an ArcSDE geodatabase

AhmadSALEH1 — Mon, 26 Mar 2018 12:50:15 GMT

Asrujit, You Are A Hero!

I have granted the SYSADMIN server role to the SDE login, I thought this would be better, more permissions means more power to the user ! which is not.

After removing the sysadmin role everything back to normal.

Thanks a lot

Re: Privileges, Register as Version commands are greyed out when right-clicking a feature class in an ArcSDE geodatabase

AhmadSALEH1 — Mon, 26 Mar 2018 12:51:05 GMT

Thanks V for the helpful notes.

Re: Privileges, Register as Version commands are greyed out when right-clicking a feature class in an ArcSDE geodatabase

yockee — Wed, 12 Jan 2022 03:44:02 GMT

Why does being granted SYSADMIN limit the capability to Register as Version ? Isnt it better to have more role ?

Need your enlightment.
thank you