Good morning,
I work on Postgresql 13 (windows) and Postgis.
For some "basic USERS", i have to grant select/read for all tables of the 12 schemas of my db ?
With Postgresql 13, i am obliged to write :
GRANT SELECT ON ALL TABLES IN SCHEMA TO username ?
Or a easiest way is possible?
With Postgresql 14, it seems to be easiest :
https://www.postgresql.org/docs/14/predefined-roles.html
I work on Postgresql 13 (windows) and Postgis.
For some "basic USERS", i have to grant select/read for all tables of the 12 schemas of my db ?
With Postgresql 13, i am obliged to write :
GRANT SELECT ON ALL TABLES IN SCHEMA TO username ?
Or a easiest way is possible?
With Postgresql 14, it seems to be easiest :
https://www.postgresql.org/docs/14/predefined-roles.html
In advance, thanks a lot for your help.
