Postgres: Role and group memberships

Role and Group Memberships

Since users often inherit permissions from groups (roles), use this to see what roles they belong to:  

SELECT r.rolname as username, 

       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 member_of

FROM pg_catalog.pg_roles r

WHERE r.rolname = 'edduser';

 Understanding Privilege Abbreviations

When using commands like \dp, you will see a string of letters like arwdDxt. These correspond to:

r: SELECT (read)

w: UPDATE (write)

a: INSERT (append)

d: DELETE

D: TRUNCATE

x: REFERENCES

t: TRIGGER

U: USAGE (for schemas/sequences)

C: CREATE (for databases/schemas)

c: CONNECT (for databases)