sql postgres

Search which role can access schema

FROM information_schema.role_table_grants WHERE table_schema='public';

Grant and Revoke which role can access DB

GRANT CONNECT ON DATABASE nova TO user;

REVOKE CONNECT ON DATABASE nova FROM public;

Grant and Revoke which role can access SCHEMA

REVOKE ALL ON SCHEMA public FROM public;

GRANT USAGE ON SCHEMA public TO user;

Grant and Revoke which role can access TABLES

GRANT SELECT ON ALL TABLES IN SCHEMA public TO read_only ;

GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO read_write ;

GRANT ALL ON ALL TABLES IN SCHEMA public TO admin ;

REVOKE ALL ON ALL TABLES IN SCHEMA public FROM admin ;