On Thu, Feb 17, 2022 at 2:14 PM celati Laurent <[email protected]> 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
> table will be by default visible,
>
ALTER DEFAULT PRIVILEGES
[ FOR { ROLE | USER } target_role [, ...] ]
This use case is why the "FOR target_role" clause exists.
David J.
