On Monday, April 7, 2025, Ing. Marijo Kristo <
marijo.kristo@icloud.com> wrote:
Seems like a bug to me.
Can someone else verifiy this ?
It would help greatly if you create a reproducer that starts from a clean install, creates the roles and database, and demonstrates the issue.
postgres=# \du vault_admin;
List of roles
Role name | Attributes
-------------+------------------------
vault_admin | Superuser, Create role
postgres=# set role vault_admin;
You are setting role to another role that has superuser which is basically pointless.
Use “granted by” in your revoke command. If that works this isn’t a bug.
David J.
