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 1prjnB-0006aA-Ci for pgsql-admin@arkaria.postgresql.org; Wed, 26 Apr 2023 18:23:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1prjnA-0005kY-9v for pgsql-admin@arkaria.postgresql.org; Wed, 26 Apr 2023 18:23:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1prjn9-0005kP-VB for pgsql-admin@lists.postgresql.org; Wed, 26 Apr 2023 18:22:59 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1prjn7-005DgR-Vw for pgsql-admin@lists.postgresql.org; Wed, 26 Apr 2023 18:22:59 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 2B411380353; Wed, 26 Apr 2023 20:22:57 +0200 (CEST) Received: from rs.plausibolo.de ([127.0.0.1]) by localhost (h2367442.stratoserver.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id TKAnT6cFvP9z; Wed, 26 Apr 2023 20:22:57 +0200 (CEST) Received: from [192.168.137.86] (dynamic-046-114-155-221.46.114.pool.telefonica.de [46.114.155.221]) by rs.plausibolo.de (Postfix) with ESMTPSA id C48C838020B; Wed, 26 Apr 2023 20:22:56 +0200 (CEST) Message-ID: <5d4cc93e-cea0-6b99-53d3-2f0c7a3d6a59@jakobs.com> Date: Wed, 26 Apr 2023 20:22:56 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.10.0 Subject: Re: how to list privileges on the database object itself via SQL? Content-Language: de-DE To: pgsql-admin@lists.postgresql.org References: <870558.1682527243@sss.pgh.pa.us> <875041.1682529779@sss.pgh.pa.us> From: Holger Jakobs In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------8eIDpgWLIsCmFhfuoQdJ1Hra" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------8eIDpgWLIsCmFhfuoQdJ1Hra Content-Type: multipart/mixed; boundary="------------vgizlLM0YjMTSd6nQkwuc0zK"; protected-headers="v1" From: Holger Jakobs To: pgsql-admin@lists.postgresql.org Message-ID: <5d4cc93e-cea0-6b99-53d3-2f0c7a3d6a59@jakobs.com> Subject: Re: how to list privileges on the database object itself via SQL? References: <870558.1682527243@sss.pgh.pa.us> <875041.1682529779@sss.pgh.pa.us> In-Reply-To: --------------vgizlLM0YjMTSd6nQkwuc0zK Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 VHJ5IHRoaXMgY29tbWFuZDoNCg0Kd2l0aCBjdGUgYXMgKHNlbGVjdCBvaWQsIGRhdG5hbWUs IChhY2xleHBsb2RlKGRhdGFjbCkpLiogZnJvbSANCnBnX2RhdGFiYXNlIHdoZXJlIG9pZD4x KQ0KIMKgIHNlbGVjdCBjdGUub2lkLCBkYXRuYW1lLCBncmFudG9yLnJvbG5hbWUgYXMgZ3Jh bnRvcm5hbWUsIA0KY29hbGVzY2UoZ3JhbnRlZS5yb2xuYW1lLCAncHVibGljJykgYXMgZ3Jh bnRlZW5hbWUsIHByaXZpbGVnZV90eXBlLCANCmlzX2dyYW50YWJsZQ0KIMKgIGZyb20gY3Rl DQogwqAgam9pbiBwZ19hdXRoaWQgZ3JhbnRvciBvbiBjdGUuZ3JhbnRvciA9IGdyYW50b3Iu b2lkDQogwqAgbGVmdCBqb2luIHBnX2F1dGhpZCBncmFudGVlIG9uIGN0ZS5ncmFudGVlID0g Z3JhbnRlZS5vaWQNCg0KDQotLSANCkhvbGdlciBKYWtvYnMsIEJlcmdpc2NoIEdsYWRiYWNo LCBUZWwuICs0OS0xNzgtOTc1OTAxMg0KDQo= --------------vgizlLM0YjMTSd6nQkwuc0zK-- --------------8eIDpgWLIsCmFhfuoQdJ1Hra Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCZElsAAUDAAAAAAAKCRCKV5yTsxlhulY5 AJ922/F1MJByJfp2X8YrNjuhBD505gCgx2sDOK0pyAbO0BwEUhpCXJlVCmc= =wtVO -----END PGP SIGNATURE----- --------------8eIDpgWLIsCmFhfuoQdJ1Hra--