Skip to content

Instantly share code, notes, and snippets.

@j1cs

j1cs/user.sql

Last active November 30, 2023 01:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save j1cs/6d2c2153e822eab98825d84155a23d4c to your computer and use it in GitHub Desktop.
Save j1cs/6d2c2153e822eab98825d84155a23d4c to your computer and use it in GitHub Desktop.
Download ZIP
check users and owner database
Raw
user.sql
SELECT
db.datname AS database,
owner.rolname AS owner,
member.usename AS user,
member_role.rolname AS user_role
FROM
pg_database db
JOIN
pg_roles owner ON db.datdba = owner.oid
LEFT JOIN
pg_auth_members auth ON owner.oid = auth.roleid
LEFT JOIN
pg_roles member_role ON auth.roleid = member_role.oid
LEFT JOIN
pg_user member ON auth.member = member.usesysid
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment