laptop and a wrench

Bug

Assigning privileges to Group Role does not cascade to participating User Roles with PostgreSQL.

Last Published: August 25, 2014 ArcSDE/Enterprise Geodatabase
Bug ID Number NIM043429
SubmittedMarch 19, 2009
Last ModifiedApril 2, 2025
Applies toArcSDE/Enterprise Geodatabase
Version found9.3
Operating SystemWindows OS
Operating System Version2003
StatusWill Not Be Addressed

Additional Information

No Public Explanation

Workaround

The user that hopes to inherit from the group role needs to be granted the privilege to inherit in addition to the membership in the role, following is an example of how a map login would be part of the editor role and inherit privileges granted to the editor role:CREATE ROLE map LOGIN ENCRYPTED PASSWORD 'md59ec9c' NOSUPERUSER INHERIT CREATEDB NOCREATEROLE;GRANT editor TO map;

Steps to Reproduce

Bug ID: NIM043429

Software:

  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options