Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q5XxS-0008Rf-KU for pgsql-general@arkaria.postgresql.org; Sat, 03 Jun 2023 20:34:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q5XwR-0002Il-KO for pgsql-general@arkaria.postgresql.org; Sat, 03 Jun 2023 20:33:39 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q5XwR-0002Ic-03 for pgsql-general@lists.postgresql.org; Sat, 03 Jun 2023 20:33:39 +0000 Received: from portal-smtp-out.hot.ee ([194.126.101.125]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q5XwN-0001s6-Gj for pgsql-general@postgresql.org; Sat, 03 Jun 2023 20:33:37 +0000 Received: from localhost (localhost [127.0.0.1]) by vm-hot-relay10.estpak.ee (Postfix) with ESMTP id 092073B7C; Sat, 3 Jun 2023 23:33:31 +0300 (EEST) X-Virus-Scanned: Debian amavisd-new at vm-hot-relay10.estpak.ee Received: from portal-smtp-out.hot.ee ([127.0.0.1]) by localhost (vm-hot-relay10.estpak.ee [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id aj9Gfodtr2+L; Sat, 3 Jun 2023 23:33:28 +0300 (EEST) Received: from mail.hot.ee (hot-relayhost1.estpak.ee [213.180.2.79]) by vm-hot-relay10.estpak.ee (Postfix) with ESMTP id CE1143B78; Sat, 3 Jun 2023 23:33:28 +0300 (EEST) Content-Type: multipart/alternative; boundary="------------mGnErwzfSi22IfJvv8LjS390" Message-ID: Date: Sat, 3 Jun 2023 23:33:22 +0300 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101 Thunderbird/102.11.2 Subject: Re: How to remove user specific grant and revoke From: Andrus To: Erik Wienhold , pgsql-general References: <568e6761-d224-7c72-59f3-267b39bde227@hot.ee> <2140448238.796716.1685796376553@office.mailbox.org> <1408288797.797459.1685797672449@office.mailbox.org> <371357275.803438.1685810290820@office.mailbox.org> <872810576.804014.1685813147131@office.mailbox.org> Content-Language: et In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------mGnErwzfSi22IfJvv8LjS390 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit 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. > > --------------mGnErwzfSi22IfJvv8LjS390 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

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.


--------------mGnErwzfSi22IfJvv8LjS390--