Re: How to remove user specific grant and revoke

Andrus <kobruleht2@hot.ee>

From: Andrus <kobruleht2@hot.ee>
To: Erik Wienhold <ewie@ewie.name>, pgsql-general <pgsql-general@postgresql.org>
Date: 2023-06-03T20:33:22Z
Lists: pgsql-general
Hi!

I tried

alter role  alekspoluh reset all

After this command pgAdmin still shows revoke and grant commands for 
alekspoluh  role.

How to remove all grant and revoke assignments for role ?


Andrus.

03.06.2023 20:50 Andrus kirjutas:
>
> Hi!
>
> > REVOKE must be executed by the grantor (sba_owner) or a superuser in 
> case you
>> not already tried that.
> REVOKE was executed by superuser, postgres. PgAdmin uses this user to 
> log on.
>> Do you get any errors?
>
> There are no errors.
>
> Andrus.
>
>