How to check all roles/user/group_role have what privileges in postgres database?

Question

I have postgres database. I want the list of users with access privileges they are being assigned.

I tried to find query and also looked in to psql command line help. (\nu and all) but I haven't found any usefull information.

Is anyone knows about that can help me out.

Thanks.

Answer 1

Here as a supplement to the previous.

To check the privileges of user by following:

SELECT * FROM pg_user;

As the same way, to check roles:

SELECT * FROM pg_roles;