📋Steps in this guide1/1

Find the roles granted to user/role

SELECT r.rolname, ARRAY(SELECT b.rolname FROM pg_catalog.pg_auth_members m JOIN pg_catalog.pg_roles b ON (m.roleid = b.oid) WHERE m.member = r.oid) as memberof FROM pg_catalog.pg_roles r ORDER BY 1;

postgresql configurationintermediate

by PostgreSQL

12 views

Find the roles granted to user/role

Code/Command (click line numbers to comment):

SELECT
r.rolname,
ARRAY(SELECT b.rolname
FROM pg_catalog.pg_auth_members m
JOIN pg_catalog.pg_roles b ON (m.roleid = b.oid)
WHERE m.member = r.oid) as memberof
FROM pg_catalog.pg_roles r
ORDER BY 1;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!