Re: How to remove user specific grant and revoke - Mailing list 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.

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.