> On Jul 8, 2024, at 13:29, Christophe Pettus <x...@thebuild.com> wrote: > > > >> On Jul 8, 2024, at 13:25, Laurenz Albe <laurenz.a...@cybertec.at> 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.
- v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE Christophe Pettus
- Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALS... David G. Johnston
- Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN ... Christophe Pettus
- Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALS... Laurenz Albe
- Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN ... Christophe Pettus
- Re: v16 roles, SET FALSE, INHERIT FALSE, AD... Christophe Pettus
- Re: v16 roles, SET FALSE, INHERIT FALSE... David G. Johnston
- Re: v16 roles, SET FALSE, INHERIT FALSE, AD... Tom Lane
- Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALS... Pavel Luzanov
- Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN ... Tom Lane
- Re: v16 roles, SET FALSE, INHERIT FALSE, AD... Pavel Luzanov
- Re: v16 roles, SET FALSE, INHERIT FALSE, AD... David G. Johnston
- Re: v16 roles, SET FALSE, INHERIT FALSE... Tom Lane
- Re: v16 roles, SET FALSE, INHERIT ... David G. Johnston
- Re: v16 roles, SET FALSE, INHE... Tom Lane
- Re: v16 roles, SET FALSE, ... David G. Johnston