topic Re: Issues with Permissions on a Geodatabase in Geodatabase Questions

Issues with Permissions on a Geodatabase

JessTate — Thu, 21 Dec 2017 11:08:12 GMT

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?

Re: Issues with Permissions on a Geodatabase

Asrujit_SenGupta — Thu, 21 Dec 2017 11:12:27 GMT

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.

Re: Issues with Permissions on a Geodatabase

JessTate — Thu, 21 Dec 2017 11:18:10 GMT

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

Re: Issues with Permissions on a Geodatabase

Asrujit_SenGupta — Thu, 21 Dec 2017 11:39:43 GMT

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

Re: Issues with Permissions on a Geodatabase

JessTate — Thu, 21 Dec 2017 11:54:50 GMT

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.

Re: Issues with Permissions on a Geodatabase

Asrujit_SenGupta — Fri, 22 Dec 2017 07:59:56 GMT

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.

Re: Issues with Permissions on a Geodatabase

JessTate — Thu, 11 Jan 2018 11:39:16 GMT

Hi, thank you, I will check the database side