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 1prjYc-0005tV-Az for pgsql-admin@arkaria.postgresql.org; Wed, 26 Apr 2023 18:07:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1prjYb-00030t-6D for pgsql-admin@arkaria.postgresql.org; Wed, 26 Apr 2023 18:07:57 +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 1prjYa-00030h-Qw for pgsql-admin@lists.postgresql.org; Wed, 26 Apr 2023 18:07:56 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1prjYX-0022Qa-TY for pgsql-admin@lists.postgresql.org; Wed, 26 Apr 2023 18:07:55 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 82E32380353; Wed, 26 Apr 2023 20:07:51 +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 4DI0BScB0d99; Wed, 26 Apr 2023 20:07:51 +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 2831038020B; Wed, 26 Apr 2023 20:07:51 +0200 (CEST) Message-ID: Date: Wed, 26 Apr 2023 20:07:50 +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> <880086.1682532301@sss.pgh.pa.us> From: Holger Jakobs In-Reply-To: <880086.1682532301@sss.pgh.pa.us> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------J00hwQWkxLgwEfuogpXzOP0q" 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) --------------J00hwQWkxLgwEfuogpXzOP0q Content-Type: multipart/mixed; boundary="------------YW8Dx2hBEmexyDF97vcDhHaN"; protected-headers="v1" From: Holger Jakobs To: pgsql-admin@lists.postgresql.org Message-ID: 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> <880086.1682532301@sss.pgh.pa.us> In-Reply-To: <880086.1682532301@sss.pgh.pa.us> --------------YW8Dx2hBEmexyDF97vcDhHaN Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 QW0gMjYuMDQuMjMgdW0gMjA6MDUgc2NocmllYiBUb20gTGFuZToNCj4gcmljaGFyZCBjb2xl bWFuIDxyY29sZW1hbi5hc2NlbnRnbEBnbWFpbC5jb20+IHdyaXRlczoNCj4+IFRoYW5rcyBm b3IgdGhhdC4gIEl0IHN0aWxsIHNlZW1zIHJhdGhlciB3ZWlyZCB0aGF0IHRoZXJlIGlzbid0 IGEgbW9yZQ0KPj4gc3RyYWlnaHRmb3J3YXJkIHdheSB0byBnZXQgYWNjZXNzIHRvIHRoYXQg aW5mb3JtYXRpb24uDQo+IFlvdSBjb3VsZCBqdXN0IHJlYWQgdGhlIHN5c3RlbSBjYXRhbG9n IGRvY3VtZW50YXRpb246DQo+DQo+IGh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3Mv Y3VycmVudC9jYXRhbG9ncy5odG1sDQo+DQo+IHBzcWwncyBxdWVyaWVzIGFyZSBtb3N0bHkg dXNlZnVsIGFzIGEgc2hvcnRjdXQgdG8gZmluZGluZyBvdXQNCj4gd2hlcmUgdG8gbG9vay4N Cj4NCj4+IEFsc28gdGhlIFNRTCBnZW5lcmF0ZWQgYnkgcHNxbCAtRSBkb2Vzbid0IHNlZW0g dG8gd29yayBvbiBlYXJsaWVyIHZlcnNpb25zDQo+PiBvZiBQb3N0Z3JlU1FMOg0KPiBZZWFo LCB5b3UnZCBuZWVkIHRvIHRyeSBpdCBhZ2FpbnN0IGEgc2VydmVyIG9mIHRoZSB2aW50YWdl IHlvdQ0KPiBjYXJlIGFib3V0LiAgKEFsc28gcmVhZCB0aGUgZG9jdW1lbnRhdGlvbiBvZiB0 aGUgY29ycmVjdCB2ZXJzaW9uLikNCj4NCj4+IEFyZSB5b3Ugc2F5aW5nIHRoYXQgdGhlIG9u bHkgcGxhY2UgdGhpcyBpbmZvcm1hdGlvbiBpcyBzdG9yZWQNCj4+IGlzIGluIGFuIGFycmF5 IGluIHRoZSBkYXRhY2wgY29sdW1uIG9mIHRoZSBwZ19jYXRhbG9nLnBnX2RhdGFiYXNlIHRh YmxlPw0KPiBQcmVjaXNlbHkuDQo+DQo+PiBJZiB0aGF0J3MgdGhlIGNhc2UgdGhlbiBJIGFt IGdvaW5nIHRvIGJlIGZvcmNlZCB0byBlaXRoZXIgd3JpdGUgY29kZSB0bw0KPj4gcGFyc2Ug b3V0IHRoYXQgYXJyYXksIG9yIHdyaXRlIGEgbG9vcGluZyB1bmlvbiBvZiBtdWx0aXBsZQ0K Pj4gImhhc19kYXRhYmFzZV9wcml2aWxlZ2UoKSIgY2FsbHMuDQo+IFlvdSB3ZXJlIGFscmVh ZHkgcG9pbnRlZCBhdCBhY2xleHBsb2RlKCksIHdoaWNoIG1pZ2h0IGhlbHAuDQo+DQo+IHNl bGVjdCBkYXRuYW1lLCBhLiogZnJvbSBwZ19kYXRhYmFzZSwgYWNsZXhwbG9kZShkYXRhY2wp IGE7DQo+DQo+IAkJCXJlZ2FyZHMsIHRvbSBsYW5lDQo+DQpcZGYrIGFjbGV4cGxvZGUNCg0K aW4gcHNxbCB3aWxsIHNob3cgeW91IG1vcmUgaW5mb3JtYXRpb24gYWJvdXQgdGhlIGZ1bmN0 aW9uLCB3aGljaCBtaWdodCANCmhlbHAgaW4gbWFrZSBnb29kIHVzZSBvZiBpdC4NCg0KLS0g DQpIb2xnZXIgSmFrb2JzLCBCZXJnaXNjaCBHbGFkYmFjaCwgVGVsLiArNDktMTc4LTk3NTkw MTINCg0K --------------YW8Dx2hBEmexyDF97vcDhHaN-- --------------J00hwQWkxLgwEfuogpXzOP0q Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCZElodgUDAAAAAAAKCRCKV5yTsxlhuj2L AJ95Wy8FzEcaObygb3W67VY6UTeKtwCffQplGeK7EQttnUYwfvq4RV0TVg8= =RIbm -----END PGP SIGNATURE----- --------------J00hwQWkxLgwEfuogpXzOP0q--