Grant select for all tables of the 12 schemas of my one db ?

From: celati Laurent <laurent(dot)celati(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Grant select for all tables of the 12 schemas of my one db ?
Date: 2021-10-13 09:04:42
Message-ID: CAHByMH1agdweY=x_NptB5ka2t6Sa6YOXY-2JfHr9Zbdwj-GS1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In advance, thanks a lot for your help.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Metin Ulusinan 2021-10-13 09:38:59 Re: Fault with initcap
Previous Message Shaozhong SHI 2021-10-13 08:48:25 Re: Fault with initcap