Re: How to remove user specific grant and revoke

Erik Wienhold <ewie@ewie.name>

From: Erik Wienhold <ewie@ewie.name>
To: Andrus <kobruleht2@hot.ee>, pgsql-general <pgsql-general@postgresql.org>
Date: 2023-06-03T16:38:10Z
Lists: 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