Обсуждение: Rolinherit- Role automatically inherits privileges of roles it is a member of

Поиск
Список
Период
Сортировка

Rolinherit- Role automatically inherits privileges of roles it is a member of

От
PG Doc comments form
Дата:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/view-pg-roles.html
Description:

Roles do not inherit the rolconfig, please see the below labs, 

postgres=> grant test_audit_app_role  to test_app ;
GRANT ROLE
postgres=>
postgres=> select rolname,rolconfig,rolinherit from pg_roles where rolname
in ('test_audit_app_role','test_app');
       rolname       |                rolconfig                |
rolinherit
---------------------+-----------------------------------------+------------
 test_audit_app_role | {"pgaudit.log=write,function,role,ddl"} | t
 test_app            |                                         | t
(2 rows)


postgres=>
postgres=>
postgres=>
postgres=> \du test_app
                 List of roles
 Role name | Attributes |       Member of
-----------+------------+-----------------------
 test_app  |            | {test_audit_app_role}

===========================================================
is there any way by which test_app user  can inherit the roleconfig of
test_audit_app. 

You can reach out to tme on my cell as well -> +919769780999

Re: Rolinherit- Role automatically inherits privileges of roles it is a member of

От
"David G. Johnston"
Дата:
On Friday, October 1, 2021, PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/view-pg-roles.html
Description:

Roles do not inherit the rolconfig, please see the below labs, 

Yeah, just like the documentation says:


Only permissions (grants) are inherited.


You can reach out to tme on my cell as well -> +919769780999

People aren’t going to do this, you should keep such info private. 

David J.