Re: Re: Revoke Connect Privilege from Database not working
| От | David G. Johnston |
|---|---|
| Тема | Re: Re: Revoke Connect Privilege from Database not working |
| Дата | |
| Msg-id | CAKFQuwa7m2smqqpgPetw=i8Aj-xqg9Zjc5Z2aX3AUwNh96WnXw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Revoke Connect Privilege from Database not working ("Ing. Marijo Kristo" <marijo.kristo@icloud.com>) |
| Ответы |
Aw: Re: Re: Revoke Connect Privilege from Database not working
|
| Список | pgsql-sql |
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 rolesRole name | Attributes-------------+------------------------ vault_admin | Superuser, Create rolepostgres=# 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.
В списке pgsql-sql по дате отправления: