Pg_auth_members
List PostgreSQL Roles and Their Privileges
Apr 17, 2026 / · 5 min read · postgresql administration security pg_roles pg_auth_members pg_database ·How to List PostgreSQL Roles and Privileges PostgreSQL uses roles for both users and groups. A role with the LOGIN attribute is a user account. A role without LOGIN is typically a group role used to collect privileges that are then granted to login roles. Understanding which roles exist, what privileges they have, and …
Read More