Dominique Devienne <ddevie...@gmail.com> writes: > On Fri, Feb 21, 2025 at 3:44 PM Tom Lane <t...@sss.pgh.pa.us> wrote: >> DROP OWNED also removes relevant permission entries (which can be >> thought of as things owned by the role, if you hold your head at >> the right angle). See its man page.
> Except when it doesn't... I'm doing the DROP OWNED, and I'm getting > several "WARNING: no privileges could be revoked for ..." for SCHEMAs > and ROUTINEs. (which BTW break my unit tests, which monitor outputs). [ shrug... ] With no details, it's impossible to comment on this. regards, tom lane