PostgreSQL alter default privileges
With PostgreSQL, the DEFAULT PRIVILEGES
can be set as follows:
ALTER DEFAULT PRIVILEGES IN SCHEMA public
GRANT SELECT ON TABLES TO PUBLIC;
All tables in schema public
created in the future will be selectable by everyone (PUBLIC
).
This does only apply for tables created by the user, who ran ALTER DEFAULT PRIVILEGES
.