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