topic Re: PostgreSql Permissions in Geodatabase Questions

PostgreSql Permissions

StevenGraf1 — Tue, 25 Aug 2015 15:00:13 GMT

Using ArcGIS 10.3.1, PostgreSql 9.3, PostGIS 2.1

I created an enterprise geodatabase in PostgreSQL using the geoprocessing tool. Using geoprocessing tools, I created a test user and added to a group role and gave the group role select, insert, update and delete permissions on a feature dataset. I also created a feature class outside of the feature dataset in the same geodatabase with the same permissions.

The feature dataset and the feature class outside of the feature dataset are registered as versioned.

The issue is I can't edit data inside the feature dataset with the test user but I can edit the data in the feature class outside the feature dataset.

Is this a bug? Limitation of PostgreSql? Thoughts?

Thanks

-Steven

Re: PostgreSql Permissions

AsrujitSengupta — Tue, 25 Aug 2015 15:09:59 GMT

Revoke permissions on that Feature Dataset, then re-grant the permission. Try editing now..

What error do you observe while trying to edit?

Re: PostgreSql Permissions

StevenGraf1 — Tue, 25 Aug 2015 15:25:02 GMT

Error I am getting is "Could not edit data in the folder or database you selected" in the start editing window.

I tried adding a user to the feature dataset instead of the group role and got the same error.

I tried revoking and reapplying permissions but that didn't work either.

-Steven

Re: PostgreSql Permissions

StevenGraf1 — Tue, 25 Aug 2015 15:27:03 GMT

Just realized I'm using v 9.3.9 and the supported version is 9.3.5. Could this be the cause?

Re: PostgreSql Permissions

AsrujitSengupta — Tue, 25 Aug 2015 15:55:22 GMT

Make sure that you have Registered as Versioned the Feature Dataset after adding any new data.
Are you dragging only a particular data from that Feature Dataset to edit?
Drag the entire Feature Dataset and check if that throws a different error.
Is data from inside the Feature Dataset participating in any Relationship Class?

Re: PostgreSql Permissions

AsrujitSengupta — Tue, 25 Aug 2015 15:58:05 GMT

No, PostgresQL 9.3.5 is the Base version that is supported indicating that 9.3.1, 9.3.2, 9.3.3 and 9.3.4 are not supported versions.

Versions above the Base version are supported unless separately mentioned as Not-Supported.

Re: PostgreSql Permissions

StevenGraf1 — Tue, 25 Aug 2015 16:06:57 GMT

Ya, there was a relationship class. I didn't apply permissions to the table participating in it. The feature class I was trying to edit wasn't associated with the relationship class. Apparently it's all tied together somehow?

Applying permissions to the table in the relationship class solved the issue.

Thanks for helping me figure it out.

-Steven