Roles and Users

[Privileges] -> [Role] -> [User]

Privileges gives permission to access database objects.

https://www.postgresql.org/docs/current/database-roles.html

Basic statemens

CREATE ROLE user WITH LOGIN PASSWORD 'secret';

Inspectations

search path

-- Schema names you have access
show search_path;
\duS pg_*

Read-only user

See Read-only User.