Issues with Permissions on a Geodatabase

[JessTate]

Hi,

I have a geodatabase on SQL server that has users and accounts connecting in but when I right click on a feature class go to Manage>Privileges, the permissions are not visible. Will the permissions be there but not visible or is there something in Management Studio that will be allowing the connections in?  

[Asrujit_SenGupta]

If you grant Privileges using ArcCatalog, then those will be listed in the Manage>Privileges window in ArcCatalog.

Permissions granted from the Database end, will not show up here in ArcCatalog. So probably the permissions in your case were granted from the DB end, hence nothing shows up there.

[JessTate]

Thank you, we apply all of the permissions through ArcCatalog but create the relevant privileges from DB end, could that be the issue?

[Asrujit_SenGupta]

Is this what you observe in ArcCatalog?

Try granting some privilege to a User (Connected as Data Owner) > Apply the changes > Close ArcCatalog > Reopen> Check if the privilege still shows or it doesn't after reopening..

[JessTate]

The screenshot is what I observe but there's a lock (account connecting in) on the feature class, even though the privileges aren't visible.

I am able to grant some privileges and they show after closing and reopening ArcCatalog.

[Asrujit_SenGupta]

Jess Tate wrote:

I am able to grant some privileges and they show after closing and reopening ArcCatalog.

So it seems that Database permissions\roles were granted to these users from the SQL Server side.

Check the Database level permissions for these users, and you should get a better idea. 

[JessTate]

Hi, thank you, I will check the database side