topic Re: Database privilege dialog won't show with PostGres database in ArcGIS Enterprise Questions

Database privilege dialog won't show with PostGres database

MichaelSnook — Tue, 20 Jan 2015 22:44:03 GMT

Hello,

I have a Postgres geodatabase that, for some reason, will not display the manage privileges on a feature dataset (wih a parcel fabric contained within) dialog via ArcCatalog. It will display with no problem on feature classes/tables outside of the dataset however. I am connecting with my SDE user with no luck. Any ideas?

Thanks,

Mike

Re: Database privilege dialog won't show with PostGres database

RobertConrad — Tue, 17 Mar 2015 20:44:32 GMT

Any chance you found a resolution to this problem. I'm having a similar problem. Thanks

Re: Database privilege dialog won't show with PostGres database

TobiasFimpel1 — Wed, 18 Mar 2015 01:10:41 GMT

I have seen the same symptom (using oracle, not postgres) with feature datasets. To solve it I had to unregister/re-register as versioned. Is an option for you?

The cause may perhaps be that you added a non-versioned feature class into a versioned feature dataset. Could that be the case?

Re: Database privilege dialog won't show with PostGres database

JillHalchin — Wed, 01 Jul 2015 14:36:25 GMT

This has just happened to our SQL Server geodatabase.

I can't manage privileges for 2 datasets, but the other three and the standalone tables are OK. I recently added a new feature class to one of those datasets and it's versioned. The only change in the other dataset was adding default values to one feature class. The next time I can get exclusive control and make sure that all edits are posted, I'll turn the versioning off and on again.

Re: Database privilege dialog won't show with PostGres database

JillHalchin — Fri, 09 Oct 2015 20:03:01 GMT

Update. I tried unversioning the dataset and wound up with a mess. To turn off versioning, I was forced to turn off archiving and now the GDB has a bunch of history tables that preserve the changes up until that time. But it means that the archives are split, with changes before and after in different tables. I turned versioning back on and reestablished archiving. I could open the privileges dialog again.

Now, it's happened again on the same two dataset, but the only schema change didn't involve either of the two afflicted datasets. I can open the dialog for the dataset that was changed. This never happened when the GDB was a Workgroup SDE on SQL Server Express.

I run compress, analyze and reindex on a regular basis.

Re: Database privilege dialog won't show with PostGres database

GaryWalter1 — Thu, 22 Oct 2015 13:51:47 GMT

I'm seeing this issue in a v10.3.1 SQL Server 2008 R2 database where two datasets were copied from another dbase. The Privileges dialog opens for one, but not the other. Even stranger, if I extract rather than copy the two datasets, the Privileges dialog opens for the dataset where it wouldn't open and vice versa. I'll have to go through the tedious tech support process.

Re: Database privilege dialog won't show with PostGres database

JillHalchin — Mon, 30 Nov 2015 16:00:23 GMT

Any progress? I'm thinking of requesting tech support, too.

Re: Database privilege dialog won't show with PostGres database

MelissaJarman — Mon, 30 Nov 2015 17:04:30 GMT

This sounds like a known issue that we have logged in Support Services. Please contact support if you have questions about this bug specifically.

Also please see if you can successfully using the Change Privileges geoprocessing tool as a workaround instead of the right click manage > privileges context menu/dialogue.

BUG-000086223 - The feature dataset privileges dialog box does not appear after enabling a recently migrated parcel fabric with the Local Government Information Model (LGIM)

UPDATE: It is understandable that using the 'change privileges' geoprocessing tool is not a solution for viewing the existing privileges. This behavior is being investigated for a future release, so please contact support and reference the following defects to determine if you are encountering the same behavior. NIM096337 / BUG-000086223

Re: Database privilege dialog won't show with PostGres database

JillHalchin — Mon, 30 Nov 2015 17:09:09 GMT

Melissa,

Yes, the Change Privileges tools works for me and I can see settings in SQL

Server Management Studio. Looks like there are multiple situations when

this arises. I'll contact tech support.

Jill Halchin

Archeologist / GIS Coordinator

Southeast Archeological Center

National Park Service

Tallahassee FL 32310

850-580-8429

jill_halchin@nps.gov

Webpage: http://www.nps.gov/seac/

Facebook: https://www.facebook.com/NPSSEAC

Twitter: https://twitter.com/NPSSEAC

Re: Database privilege dialog won't show with PostGres database

MelissaJarman — Tue, 01 Dec 2015 00:56:16 GMT

Yes please contact support and provide the various workflows that lead to this context menu for permissions not being available. This can be tested inhouse and added to the existing defect as additional workflows to reproduce this to help the investigation of the cause of this issue. After this is verified by our support team they will associate your customer number to the defect.

Re: Database privilege dialog won't show with PostGres database

JillHalchin — Fri, 04 Mar 2016 14:08:18 GMT

UPDATE: I was contacted by Esri specialist Sam, who had seen a similar problem with geodatabases containing topologies. He sent great instructions for running some experiments to test his theory. It turned out that the problem was caused by the fact that our GDB had relationship classes inside datasets. Once I moved them out of the datasets and to the top level, the privileges dialog worked. So, in the end I had to used a workaround, but only a minor inconvenience. The GDB looks even more cluttered than before but at least I can easily check and change users.

Re: Database privilege dialog won't show with PostGres database

SamuelTompsett — Fri, 11 Mar 2016 21:10:46 GMT

In response to Jill's post. If you are still encountering this issue, please contact Technical Support. There is a software defect logged to address this behavior.

Thanks,
Sam

Re: Database privilege dialog won't show with PostGres database

HuongTran2 — Thu, 27 Jul 2017 20:43:01 GMT

Ran into the same problem because I had a relationship class inside a dataset was working fine until I gave access to a user to view the dataset then is when the ménage on the dataset stop working. Now I will have to move my relationship classes outside the dataset which will make my database cluttered. I hope they will be able to fix this issue soon.

Re: Database privilege dialog won't show with PostGres database

JosephRathvon — Thu, 15 Feb 2018 13:11:40 GMT

I had relationship classes in my feature dataset and it was no issue untill I added more layers and the relationship classes for those were outside the dataset. Once I found this thread and moved all of my relationship classes outside the dataset I was back in business.