4259 links
  • Arnaud's links
  • Home
  • RSS Feed
  • Tag cloud
  • Login
search: tag:postgresql tag:role tag:permissions — newest first
  • pgadmin - PostgreSQL, display role members - Database Administrators Stack Exchange

    SELECT r.rolname as username,r1.rolname as "role"
    FROM pg_catalog.pg_roles r LEFT JOIN pg_catalog.pg_auth_members m
    ON (m.member = r.oid)
    LEFT JOIN pg_roles r1 ON (m.roleid=r1.oid)
    WHERE r.rolcanlogin
    ORDER BY 1;

    August 12, 2019 - permalink - https://dba.stackexchange.com/questions/136858/postgresql-display-role-members
    permissions postgresql role