Postgres Pro
Downloads
Home   >   mailing lists

Re: How to remove user specific grant and revoke - Mailing list pgsql-general

From Andrus
Subject Re: How to remove user specific grant and revoke
Date
Msg-id c8a918fa-3f8a-0ddd-12a9-85d8b24f3e22@hot.ee
Whole thread Raw
In response to How to remove user specific grant and revoke  (Andrus <kobruleht2@hot.ee>)
Responses Re: How to remove user specific grant and revoke  (Erik Wienhold <ewie@ewie.name>)
List pgsql-general
Tree view

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.

pgsql-general by date:

Previous
From: Erik Wienhold
Date:
Subject: Re: How to remove user specific grant and revoke
Next
From: Erik Wienhold
Date:
Subject: Re: How to remove user specific grant and revoke