View - Pasted

PostgreSQL |

190 B

None

0 👍

0 👎

Raw Download Clone Embed Print View

SELECT rolname 
FROM pg_user 
JOIN pg_auth_members 
ON (pg_user.usesysid = pg_auth_members.member) 
JOIN pg_roles 
ON (pg_roles.oid = pg_auth_members.roleid) 
WHERE pg_user.usename='username';

Pasted

psql - View group roles for a user

Comments