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

From Erik Wienhold
Subject Re: How to remove user specific grant and revoke
Date
Msg-id 371357275.803438.1685810290820@office.mailbox.org
Whole thread Raw
In response to Re: How to remove user specific grant and revoke  (Andrus <kobruleht2@hot.ee>)
List pgsql-general
> On 03/06/2023 18:14 CEST Andrus <kobruleht2@hot.ee> wrote:
>
> > Or just execute those REVOKE ALL commands (except for PUBLIC) that pgAdmin
> > already gives you.
> pgAdmin gives
> REVOKE ALL ON TABLE public.kaspriv FROM someuser;
> I ran it but pgAdmin still gives this statement.

What are the current table privileges when you run this in psql:

    \dp public.kaspriv

--
Erik



pgsql-general by date:

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