On Thu, Feb 17, 2022 at 2:14 PM celati Laurent
wrote:
>
>> ALTER DEFAULT PRIVILEGES IN SCHEMA XXX GRANT SELECT ON TABLES TO "user";
>
>
> Does a person know how to give privileges to a SuperUser role so that when
> he creates a new table, whether in the public schema or another schema, the
> tabl
Good morning,
I'm a superUser. I have defined different roles for several "simple" users.
They have rights for
read/select/use on any existing table. And also on any table that will be
generated in the future (DEFAULT PRIVILEGE).
Here is my method:
--FOR PUBLIC DIAGRAM
> GRANT USAGE ON SCHEMA pu