PostgreSQL 18 · Databases and roles
Grant table privileges
Let a role read and write all tables in the public schema.
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO app_user;
Official PostgreSQL 18 documentation
PostgreSQL 18 · Databases and roles
Let a role read and write all tables in the public schema.
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO app_user;
Official PostgreSQL 18 documentation
Was this page helpful?