Re: Alter default privileges is not working for roles

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Teju Jakkidi vlogs <teja(dot)jakkidi05(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Alter default privileges is not working for roles
Date: 2023-02-22 18:32:58
Message-ID: CAKFQuwbdbeRauJwo6RMS1aBq5yVnUAbwOQQs7B=n89RKTLbD9w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Feb 22, 2023 at 10:53 AM Teju Jakkidi vlogs <
teja(dot)jakkidi05(at)gmail(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2023-02-22 21:03:31 Re: Alter default privileges is not working for roles
Previous Message Teju Jakkidi vlogs 2023-02-22 17:52:53 Alter default privileges is not working for roles