Postgres Pro
Downloads
Home   >   mailing lists

Re: Alter default privileges is not working for roles - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Alter default privileges is not working for roles
Date
Msg-id CAKFQuwbdbeRauJwo6RMS1aBq5yVnUAbwOQQs7B=n89RKTLbD9w@mail.gmail.com
Whole thread Raw
In response to Alter default privileges is not working for roles  (Teju Jakkidi vlogs <teja.jakkidi05@gmail.com>)
Responses Re: Alter default privileges is not working for roles
List pgsql-admin
Tree view
On Wed, Feb 22, 2023 at 10:53 AM Teju Jakkidi vlogs <teja.jakkidi05@gmail.com> 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.

pgsql-admin by date:

Previous
From: Teju Jakkidi vlogs
Date:
Subject: Alter default privileges is not working for roles
Next
From: Tom Lane
Date:
Subject: Re: Alter default privileges is not working for roles