Search Postgresql Archives

Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




> On Jul 8, 2024, at 13:29, Christophe Pettus <xof@xxxxxxxxxxxx> wrote:
> 
> 
> 
>> On Jul 8, 2024, at 13:25, Laurenz Albe <laurenz.albe@xxxxxxxxxxx> wrote:
>> I didn't test it, but doesn't that allow the member rule to drop objects owned
>> be the role it is a member of?
> 
> No, apparently not.

Just from a quick check, it looks like you need INHERIT to inherit the ability to drop objects.  The documentation strongly implies this, although it doesn't quite come out and say it.





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux