"David G. Johnston" <david.g.johnston@xxxxxxxxx> writes: > On Wed, Feb 22, 2023 at 10:53 AM Teju Jakkidi vlogs < > teja.jakkidi05@xxxxxxxxx> wrote: >> alter default privileges for role ownerrole >> Now our expectation is that if there is any table created by any user > The specification of "ownerrole" in that command means that said default > privileges only are created if "ownerrole" is the one creating the objects > - not "created by any user". It's hard to say for sure when we've been shown no details, but I suspect what the OP is describing is event triggers that issue ALTER OWNER commands after the fact. The default privileges mechanism is only applied at the instant of object creation; we do not want ALTER OWNER or SET SCHEMA or similar commands having random side-effects on existing privileges. regards, tom lane
