Last active
November 30, 2023 01:01
-
-
Save j1cs/6d2c2153e822eab98825d84155a23d4c to your computer and use it in GitHub Desktop.
check users and owner database
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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