On Thu, Feb 20, 2025 at 9:21 AM Dominique Devienne <ddevie...@gmail.com> wrote:
> But that's not much better. It's basically like the SET ROLE to the > GRANTOR I did. > I guess what I want is GRANTED BY ANYONE! And not have to figure out > GRANTOR(s). > Your stated use case is dropping a role. Does the combination of reassign and drop owned not fulfill the requirements? https://www.postgresql.org/docs/current/role-removal.html Also, you had to know the role you wanted to drop so you already figured out the grantor. David J.
