PostgreSQL users

• show users;
• select * from pg_user;
• \du

• create role USERNAME with login password 'PASSWORD';

GRANT pg_read_all_data TO xxx;
GRANT ROLE

Related

• PostgreSQL predefined roles: pg_read_all_data
• PostgreSQL Privileges
• PostgreSQL superuser
• .pgpass

See also

• PostgreSQL users, predefined roles: pg_read_all_data, pg_monitor, create role, .pgpass, PostgreSQL read only user