Assigning privileges to Group Role does not cascade to participating User Roles with PostgreSQL.
上次发布: August 25, 2014ArcSDE/Enterprise Geodatabase
漏洞 ID 编号
NIM043429
已提交
March 19, 2009
上次修改时间
April 2, 2025
适用范围
ArcSDE/Enterprise Geodatabase
找到的版本
9.3
操作系统
Windows OS
操作系统版本
2003
状态
Will Not Be Addressed
开发团队已考虑过该问题或请求,并决定不会解决该问题。 问题的“其他信息”部分可能包含进一步说明。
附加信息
No Public Explanation
解决办法
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;