deeejay

psql - View group roles for a user

Jun 5th, 2014
521
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT rolname
  2. FROM pg_user
  3. JOIN pg_auth_members
  4. ON (pg_user.usesysid = pg_auth_members.member)
  5. JOIN pg_roles
  6. ON (pg_roles.oid = pg_auth_members.roleid)
  7. WHERE pg_user.usename='username';
Advertisement
Add Comment
Please, Sign In to add comment