Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1up7yq-00H8IX-6F for pgsql-general@arkaria.postgresql.org; Thu, 21 Aug 2025 16:17:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1up7yp-00HR2z-Iv for pgsql-general@arkaria.postgresql.org; Thu, 21 Aug 2025 16:17:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1up7yp-00HR2r-4V for pgsql-general@lists.postgresql.org; Thu, 21 Aug 2025 16:17:35 +0000 Received: from mout.gmx.net ([212.227.17.21]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1up7yn-0012qJ-0A for pgsql-general@lists.postgresql.org; Thu, 21 Aug 2025 16:17:34 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1755793049; x=1756397849; i=karsten.hilbert@gmx.net; bh=CGcGm9u7cPJ3SYQm4+aOc3h/clZRigK5JMDn8iHW/9U=; h=X-UI-Sender-Class:Date:From:To:Cc:Subject:Message-ID:References: MIME-Version:Content-Type:In-Reply-To:Content-Transfer-Encoding: cc:content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=Ner57RMSUvkWSHftJgEwvBgJZ7vzLvnMuN7FS8JASFLEZpDs9p1aqGT6OGUUDZVp qYyl3Fjd8sq5x4y/8x9Ht2VIkqqWxWYNAHbX1gLqhz3QQVvPhRZSBTlTBz8muPc69 NCZ40tGGdaaf5jXOu7yLr8sb8rmIOxG2aazwdcRyjurA47BKjgOJZiK6ZBFUMbuL2 tmUN17mvLem31XhVpNdoTfRbMyAzlM7dHDJDIxgpainyvrdfs1+JTpBP6MRTGwhGK Vb73DC3etgPjNPyGtjEnpYHW/LFzFrkjZPgsyhFE8/zYKr24L2qy9kZRRjbK7mwf6 x0LEVOvps7SFmwSjjA== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from hermes ([84.190.227.182]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MMobU-1v5YOz03HQ-00UKWJ; Thu, 21 Aug 2025 18:17:29 +0200 Received: from ncq by hermes with local (Exim 4.96) (envelope-from ) id 1up7yi-0000Cp-1s; Thu, 21 Aug 2025 18:17:28 +0200 Date: Thu, 21 Aug 2025 18:17:28 +0200 From: Karsten Hilbert To: "David G. Johnston" Cc: Adrian Klaver , "pgsql-general@lists.postgresql.org" Subject: Re: Q: GRANT ... WITH ADMIN on PG 17 Message-ID: References: <3662a9b9-3e58-4977-8bd1-e1ed0e25b2a8@aklaver.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: Ma_X_il-Followup-to: d Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri_X_ority: 2 (High) Sender: X-Provags-ID: V03:K1:vwu392OCwVZZAy6z7iMGxWlHf9L17yL0AaE+sm4WgT3PqMtf80Q Rqf+/K1XWRHYTPRBQNAmWSbWHRPNCdKNFAupf9j86a0j0QvIn0NH3POOPVUvFmF9oly2LI4 V7jSMRV6BipF+56xTNKRqIquWqEwrWH2reC0Lc8nhEUEHOJgF/JWrohzmQM/jNulAJZt+30 rWga8fvSyxIHtNVY0e7wA== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:5oj3/OG3YTA=;ifD2TmD7JvF1OJiJ05hLSMfhpQr vXFBt1rdmRauf6wJbI9DBGMivxqdLzvprsFB2IS/VccxIl2iOGtnqdPjyJKcgg2mZ0ihvI+bD qj9S38xOMtfAxTE8kyk15O8C9S9uvTIlM6peRe6SuTYszK6Bik1hY9+Ht1R+k38GRICG0BQ1h ZSRpt0t1Ke6qm+W3wXUMjWflz6J0gLcp9/tV+CW72kXQv4Yo9SHHsGY54VW7zcyYoTXYNAw2d O4zFgGLf4jLVZ9YmoILPF7tGte98drBuzw+1gmdufdLAhGa/jOG2yxyt7T4lvzh1qqjsL9gSP XT1er/9+xMGOg0q7GsQtCVqZFaZA5pfFp7n0WAkX524AOHtr2B0Rvl0DR/4sX840EnXvOJB45 0X7lFi/ve3UOUUEmwzbFxbhqSpQGGlRLYHreaIy3swoTkgBIHzzcFClvQ4Cs8e2bawczA0bpW lzSatw7XDhwj4IoCUMo2IZ+8GcR89uE0PhiSqx0KPEovJ/fyYkRMINHc/UQby8P87XayP7WDK 40reOJgaE+jaTu0od225VpWPDx/Ij3OTQ8GRiW+VZqWJWOoNO2dTKYtqX9lXPLTKRVjMlKO8M cXFnOZn23DfdNBfKf0DGe4VX4hICnOwa1JhtVU5IR3q9Qm59q0tr6e7RHeO0PSp0A7KWZeAAU YQIJbHJNEColtpbHWrBjuCkvqvWQVngE4rHTAQEj7m0fZ1hNZ/XeHtnhW+pyALgolg7cwWvzG yjiE0JzXIbKIYbjpAQYm+rCWzMdeIrFLCkL4yxcs/XYZTe/Y/TIXzhdJ/EAjFp/zdxv1mJ20R T0zktiCffqdm+gipAllxn6i5C6KH5qdDyPbVtDjKHTjU/LqVsqNIYmFyUDWDzot6RSAe1/HBH nLGayTVlKZle0utbjgK+KS2uJQeGVChKpOmGmbA8jl3sMAh3W/s6Sn5H9MbX/Xgy+CyvchyaB LY2mtYF/1kkA0bmpVHxOlu/npOzvt2BSunGZPyRMZKvpNsIgzE3VZ9VeafyE5lvBOxiobh8Vr 41n3JClWC3Kd6Gt/aJ4uAnT0KTt87uf0fhDZSLmS2DHHi0XszzrS1J0AAfrLVfpxOjon01Cic 5Pe46+fBcsqxFt0i5MTYgwuZocD8vAShAqTSfJ8A/WuPV/+p04HS8YqjOQM1veZicbVmDjjuD 5WPdQ/V+ALFQnOO8705SpmfiPBzJczmx9lZ35KmSigEob5ChM1CoDa1fXR+ODfwhM8yQk/dc6 Uf5Fp7QcNa7xyvHXEK7Ljat0N1n4plpC+XP+zvEnRd2tF5iaSADW3S2K2PjcZuZOtHuA3IMyz 46Ti9UVjMGin8Z9+CgxbpvSh+rS/u8XZy9YNT5305jxs8tFw3Z1evO8IPDZ+OOSii14UhDEZ8 UEb+ih9g6onmGQGqtC5mYnzNHPEe6QGhMEeG99NEddpAJ0ODTnRd0VCbLaeD6a3XFmpHTZiwD mTUYcAcQCpMYoPMzVriHN85k2v35OVqqeG949bXIzdOgJpQZ2/dvUcQv0U1M653G7lVYgzesC 1H5S9RBYdnu2GpB76v6+GDguj3SRYWeDkmxNiTCDBXvYiseespzwrgkqkgtosXbjXiGFkLvkk 3qMMrOikwOTXAsr/p6+wiNpskRUAnATyu+57t3aNbR/7K0ljSC+zY5M04oSsybR/UiTKcQx9h GNu8atL2eLvx+07kdNM58xqeMhlyvRMyylBDrNO/aCXDt2GyJIVZKSepsk9rYT2X9EUIM8+mw yL14fWpmci/WvpsPFCcPJtMKvijLA80VSOOO/aFJFLDCZepOLXBRwpPq1KhJooE/zrA8TFNKr zvK7BvD1X/tR7YLm5pO3IY3Fv/EJQqHQ0BztVfcpAhtFFx+Hrna3wq0t6PppWNwX7FrIz21LV M/hY1RdZ1BvLsTERYTj2AC5gNLORPmJY6SRnDutV5zi+sUDxpFUVBfN9tNuclrOdGT4V+7ZKA mL1KLjJVnlZPnNReVrB1E0nzFEQebBUutBxbx/7xYJTnNKrljzWrCSus0lxSvLavzeBsQi0ri 5Ol2+3yW+O4uuYUKqiQP32y0cglKvgfMJWn1n3tjj8ZR7SdY5WOBodV/HuXDuhHQZ+Q+WpRBL D+9ELlGFMTAmRTDcmU9v7RhoLv7HJbi1tAw7qawRz90ZkEHMdkmfKN+Nr4LShz8O+NBooyrQ6 p3GsbP+7dlShIugkbkWxevYM1gJvLM1k4ZiEp8PaXDN04tEG9NfEOrFxcqgpSefTgqARfYjLV u8/OQrTLlWliAaQOyW0KjQiYHbzftrTjmcYSg1IGEdfs/GxfJzfpyPZ9vC9r1CvPD6qpVE5+K x1oudfM/pbHEK/PtcFGXS9lUp4jiQc2OMTNvV4kRr7zY4hJDFZnWI6JoSuAVK6DUU7j7FbNBV hmv+qQl2X9wgX6q1f7AVJliloC3/LYErNbEgEC2CD+xydeXf0JsnKZoAW43HebqE9hYpkZT/B +9ncI1du1FeKD3aurJ/PX9GkTrmZzYYJKA5CswvJNWUqnrczFygWg1Wx8mKnnmZ2tW6vOPpZm meavastJ1rlq5CLmx9RUAn2RJ0f7HsHjt/QStepV4iHDedJ7Ka2eK9YKEbatDsoSgttxoKmeZ Hd3AhT4RuH9CEwguYnVHQAxmcUOiQLnWFbiLMsc/I3I7Wl+ne+fILMbwAwUMARYZYXONoyu0D EU50Yc+ZHHg4v0b14S3FPIKIvOJdnsCTlpfI41XLK4uXRKWJsBhaCqGRrC4Aby9R3gJ5eZ6yc nGjEb/KTODuKxT9Sr5uxWrbT5dX0wKuE8kW0gbqTy17DU87Wl3vAh2fVxUC5bsuHLWLmaa2Wm bbUWdVT9RYB9qjLtrY9L++8hMRhW8iBg2Zdpo/G0zMlc1T91uK0nGtB4NorAKFbwe0HK9bcPM O4bgrNKKN0LeHyM2xrp4mx2ELXpy6MB7XObRXRwQEmOn/0D/MqLHkeCP0BzOHmkpVgjHtfJRy pk3BN4EFY4KrpiZYB8tJdbWJMEmKT4fJ5L0pws2q0ClhgUufzQFc9Ixs2/R9F+pXSI1mtQCjp Eg7Y/5uqW0tpfUMXtlcKRvuhMtHRsX9O4+83LWze62nXhwugvnYi6E7eslcYADVG6/UZQ+q61 x46qbSRDZ63p5rkESitcis1X8aykpyQphBc8pampzUaAmRgXh2lJ65Qux9NdUS2omhYcicdLk s7IPTG+kaY84bAedScwBIt480UtdSygdaI5qzSMiUw2+ubHH9MvC4MD/ycLIhJYDMvAqqF/ct IGXG1xWQUQLIGaf+vYjGbRxw015VgNOgO1XejpdX7f15dV+xQxsuwzl+rq65yhyU7+LAwXeaQ xM/U6+DHIjhqcQ/skU7kXS/LVQE6ItQVKwe0duD5Ey24qkxuUX/OrQ1nDV+ZgSu6DFFZEZFyZ KHFRHySQGvEPjCXRgVTae/KhNX0jvKbKLci7biWviXkHLUfFvvQclVJ1misIleWyoE1MDzH6F yUNNc+NygCcY1luyHUMld182Fl53fq47ym5++4FvOP0P5KmoGcpscUnGcQeRRlJ1MkitH0yT2 /lRlYkEU1SAozUTcRPYDX2ZBemIYnP9hrpVRlDdy8KubLx/Vhrqx0QA5khBwQUpAGl63oq4Et NPjPBA2Ys31KEzt40I4OYYoWAW/7tyAYKg9WTHSKfLjV4N264uvnto52RgZDx8AKwSsh85/ui zmajlxyr7w3cfnmyaSsrjFYQNIgPorGghhmylG4eQoKbDRiVlvK9ITch3ymtjVE7PMBpq6MBx QzJ2ongr8FF1VpwWrv12Z3rHO0w1IHIfnVlqyExyKewhGqjCRW34KKWsd3kAzdcV47LYNBA1z EzYlcBfrJadd/kn7QVPkEsNqO/CWjYDdZP36iz5HAulCPxEZs0IABOiL2KFEJKmNnJJk7vZY7 MQQFTA3l4gWlN6B0TM9DrWfy62/X45QT/Mhlm2+XQuDLI3X9f01237jXijUOIjlmdqPZTzfCT zSPS/fYW0LWNCH5pijvqKH+47/CximrszOQuy3Qt9OoxxhGy43B8kavJtXotDkNy5bfUkSj7y 2Inq68rhvAQiU9PDbklroAhxhe9OQB3gzrekiyDoT7OjTOeXY2Eu5/WKtyTQtnqRWVZYxqkw1 ACbtSZ8CvIqpTnbiUpI5C7neYzWGdEIldvAxptzWboW8VCrZ0MgahLvMn+b6LVw1Xw0K0q6QB rlYmu7gwHSznDBhTXiuw4HnpSfXi31a0msx6JlRRenghP7Rr7aqoPo60356g+d//HPx5nNl3v e3qMnm66sSligt2CxFg/2AVMTPi+iJndMtA+idlVdPTdffR8M0MdRAmsglynJiqo1JuHTpYoF yEUkd6wLG3daMX68cG17CsiYcAjKcbxKw8V2gnOEc53joqSerK/hAGTWA6PHBoiPdKtJMR1yK umtw4m2kUFmyu0lVxzeJrDJO0a7gOWVGDuh3niEkQ++NZToTMVvv8h3jiAvy9suVxeqpw0g4D y7Kr4Aenst+JKlKgFR6OLt1a1UM16VPg/quTQjSB8K6u+0n50hqYW2kE2GoghDoh1m7WOWHC8 7ujIxpPDcNU6ABImTLgx7Yv5sfcGhVH3BQ6svlXryUlWUxcKfxxnq3VztrxmLDfJ5oLQ== Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am Thu, Aug 21, 2025 at 09:11:57AM -0700 schrieb David G. Johnston: > > Thanks, I did, but did not find the answer to: Is there a > > way for a role that can manage membership in a group role to > > not itself be a member of that group role ? >=20 > A superuser can do this. Otherwise, no. In order to be made admin of a > role on must be a member of said role Thanks, fine, that makes it clear to me. Regards, Karsten =2D-=20 GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B