Grant access

Grant read access on database:

GRANT CONNECT ON DATABASE database_name TO my_username;
GRANT USAGE ON SCHEMA schema_name TO my_username;
GRANT SELECT ON ALL TABLES IN SCHEMA schema_name TO my_username;

Grant all access rights on database:

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO my_username;