GRANT CONNECT

• https://www.postgresql.org/docs/current/sql-grant.html

• GRANT CONNECT on database YourDB to YourUser

• GRANT ALL PRIVILEGES ON DATABASE

• GRANT USAGE ON SCHEMA your_schema TO GROUP your_group;
• GRANT USAGE

Related

• Read only: PostgreSQL read only user

See also

• ALTER, ALTER DATABASE, ALTER TABLE, ALTER DEFAULT PRIVILEGES, ALTER MATERIALIZED VIEW
• GRANT, \ddp, GRANT USAGE, GRANT ALL PRIVILEGES, GRANT SELECT, View GRANTs on Redshift, has_table_privilege, has_schema_privilege, HAS_DATABASE_PRIVILEGE, SCHEMA, Privileges, GRANT EXECUTE