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

Reply via email to