Re: Alter default privileges is not working for roles

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

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".

David J.