ROLE/USER privilege
select * from pg_roles;
rolname | rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcanlogin | rolreplication | rolconnlimit | rolpassword | rolvaliduntil | rol
bypassrls | rolconfig | oid
----------------------+----------+------------+---------------+-------------+-------------+----------------+--------------+-------------+---------------+----
----------+------------------------------------+-------
rxxxxxxx01 | f | t | f | f | t | f | -1 | ******** | [NULL] | f
| {default_transaction_read_only=on} | 17211
pg_signal_backend | f | t | f | f | f | f | -1 | ******** | [NULL] | f
| [NULL] | 4200
select * from pg_user;
usename | usesysid | usecreatedb | usesuper | userepl | usebypassrls | passwd | valuntil | useconfig
-------------+----------+-------------+----------+---------+--------------+----------+----------+------------------------------------
dp-postgres | 10 | t | t | t | t | ******** | [NULL] | [NULL]
axxxxxx01 | 17205 | t | f | f | f | ******** | [NULL] | [NULL]
rxxxxxx01 | 17211 | f | f | f | f | ******** | [NULL] | {default_transaction_read_only=on}
table privilege
select * from information_schema.table_privileges where grantee=''
also can use " \du+ "