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

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема Rolinherit- Role automatically inherits privileges of roles it is a member of
Дата
Msg-id 163308731354.27923.7395248143618893977@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: Rolinherit- Role automatically inherits privileges of roles it is a member of  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-docs
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

В списке pgsql-docs по дате отправления:

Предыдущее
От: Anton Voloshin
Дата:
Сообщение: Re: [PATCH] fix ICU explorer link in locale documentation
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Rolinherit- Role automatically inherits privileges of roles it is a member of