Re: How to remove user specific grant and revoke

From: Andrus <kobruleht2(at)hot(dot)ee>
To: Erik Wienhold <ewie(at)ewie(dot)name>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to remove user specific grant and revoke
Date: 2023-06-03 20:33:22
Message-ID: c8a918fa-3f8a-0ddd-12a9-85d8b24f3e22@hot.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Erik Wienhold 2023-06-03 20:57:56 Re: How to remove user specific grant and revoke
Previous Message Erik Wienhold 2023-06-03 16:38:10 Re: How to remove user specific grant and revoke