Re: Re: Revoke Connect Privilege from Database not working

On Monday, April 7, 2025, Ing. Marijo Kristo <marijo(dot)kristo(at)icloud(dot)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.