Re: Give default privileges to another SuperUser ?

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Thu, Feb 17, 2022 at 2:14 PM celati Laurent <laurent.celati@xxxxxxxxx> 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.