On Wed, Oct 13, 2021 at 11:04:42AM +0200, celati Laurent wrote: > 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 ?*
Yes. For each schema. You could write a DO query, or even get psql to run it automaticaly-ish for every schema, but it will still be separate query for each schema. depesz
