Taula de continguts

To check the privileges of user by following:

SELECT * FROM pg_user;

As the same way, to check roles:

SELECT * FROM pg_roles;