Re: How to remove user specific grant and revoke

[Andrus]

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.