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 (
This does only apply for tables created by the user, who ran
ALTER DEFAULT PRIVILEGES.