Re: How to remove user specific grant and revoke

From: Erik Wienhold <ewie(at)ewie(dot)name>
To: Andrus <kobruleht2(at)hot(dot)ee>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to remove user specific grant and revoke
Date: 2023-06-03 16:38:10
Message-ID: 371357275.803438.1685810290820@office.mailbox.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On 03/06/2023 18:14 CEST Andrus <kobruleht2(at)hot(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2023-06-03 20:33:22 Re: How to remove user specific grant and revoke
Previous Message Andrus 2023-06-03 16:14:03 Re: How to remove user specific grant and revoke