Re: Give default privileges to another SuperUser ?

2022-02-17 Thread David G. Johnston
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

Give default privileges to another SuperUser ?

2022-02-17 Thread celati Laurent
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