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 1up8IT-00HE6n-Vi for pgsql-general@arkaria.postgresql.org; Thu, 21 Aug 2025 16:37:55 +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 1up8IT-0000AT-BJ for pgsql-general@arkaria.postgresql.org; Thu, 21 Aug 2025 16:37:53 +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 1up8IS-0000AK-Sv for pgsql-general@lists.postgresql.org; Thu, 21 Aug 2025 16:37:53 +0000 Received: from mout.gmx.net ([212.227.17.22]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1up8IQ-0012yj-2O for pgsql-general@lists.postgresql.org; Thu, 21 Aug 2025 16:37:52 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1755794268; x=1756399068; i=karsten.hilbert@gmx.net; bh=1pkHsQYLIlEuWdbAfJho8ecJgrxba9xJPG40xz85TXI=; 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=m67q+z3Df6tbyRJnfw0hPSKQxafhxMde1q2h6zgDiaadbcHCWCOKbcNTiIuJSnWR 7UJsXyym1eI3oAuYUDKPUJd0d+zkK+cUWDhLOAXLxNnoxJG2HSnaRW4GbbtHuZ5Gu oixDngUnAEosUzVmu6Zo3luUyPuqEInllpFaN7w3hWsc54GchV7Eqfoxwf8MdLtaw l/vbQ5X0QCN3aymrdzLYtWurhb2xP9ms/X9HR+V7tWdQrc3WNNAwcd2uN4qHJK4lY mTvHoAGIkfB/3v7CceXXePs0xd+FcI19YlIIrdOhxI3Pr5mTkzSKRhXKYyE+qfzp6 k2u/256nE8Z8UhTbrQ== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from hermes ([84.190.227.182]) by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MtfJX-1uXs1b0K23-016iFs; Thu, 21 Aug 2025 18:37:48 +0200 Received: from ncq by hermes with local (Exim 4.96) (envelope-from ) id 1up8IN-00016Z-2C; Thu, 21 Aug 2025 18:37:47 +0200 Date: Thu, 21 Aug 2025 18:37:47 +0200 From: Karsten Hilbert To: Dominique Devienne Cc: 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:vYmW6Xupg/QFMVs/EevNimhx0ERiL+RMk/lm6bd/jDRIiRPo1sT qqy7hEqTo+WFI2gv2V6NdYlNcQKRPr66UW4DhgV9WBLI7paNH+IFz8xPM0CHuundgmSLn5j NhS3OmNaEZlC9FGezIzFuY5NZ4FG67MoAymaS20d5Mh92XqbMGVvh6O1EFESZWgDr+/eiCT Bj+bbovCSMUEjy623NnRQ== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:W5USTyiEIPo=;vjDykn7Gmtx2tdu/b8AHxlXyEb6 IcG2r8lBJwCIQDf2AYjs5hGtHlhnjXysd1+3TqcW3o1TZVSkxQoXsNJTkhtpvXqmR+fh57deK v7fIth9fnfD76PPwJtiWUGaye0N+2weAU2oDv3st2SUt9aQ/LjoHKNkIPCXX/jQWeJMd2aPHl LniulQjIuxq+QXvH2JVylLClD2KhlwReCUg09RjBYomXzdh6VO8jFJY8nCBJGd2adJPB5R1q2 wzdtgZkuwraqPpijx2hbZ2+mDHf6PgNykug7r9j/rU7UFhlAOoTvdQrl8PbQKrLGdqw96MthQ AFu+pqv7RE0MgBMFqkUUGXooYY7cHo2rbM4rHJ9T4Y2yIrjc5J0qwdkwdv3vrPlnsv84IC94c uKFFIHaY4SlLPRSH23Ga+WGJzOIaVOcvjWA7EVNk34bgNlMwbFPaZLYB20Eg7ZYv4k4Z0blQ1 V7e5jfsfoAxjKmCvl0Mu9/7yMYBDlpIKWinyaBAxefwtvM2WfLPcG0r5d08kEwAq2BC8NqDm2 Fh7OGcUYqu6yM2ynGdfz830KNtb0zxOq82Bfv2k27CIyf+CTo1v2rFdWZgN8NPzvj63C7T+K6 k/MO0CJQKFSVAhbLvYORxGU1cMEwTvC9ypXtsT0S0TarrVGhRDW9eZ//MPal4N3yUDTiA6KfH DS47JTN88e1yPskkDkOaXbRqbuRG+9DvizjWOMJrNIbtWEHYfmlQL2cDNP9or8WtXje2EBZdJ H9IgWQ8zeukboQ7PIshzomc71DpD1Msa10buAbE4sChMIYu2MehDIDBNYztVaMF2R/2LTW9YZ aliv23h2fev1j4/AhOIyQSjYg4CbFEZ9b82MfaEELTvwAAEnzEPOZUI8TA9beEf8AxCuXInt5 pMVNI+NoqFr1AC8Csk453HFxNXh32HPckz3hV94X1avMXrIbbyw/KaChe5BIA07328J4BoI49 4AH/hYplyGlVl/fgDB8zITlE4VtzPQzR2UA7x/xyXZPsdft0B/ztLoNrRWwiKM/PX40NcwrYj /h+e+v82mBG2PIv1247quLSicooxPPZvHcJmZ0xXpSkHoTSVjs3yP/esuLt0MtqxA4SHWVh0K 0eaj9QBRvb73OrRGWizL7IjExdvrLIaGfAM9VWKtqCFzaQqwdfg63+DlYoo83b1FAehAuU4w7 GOIqct9jJ/BOfbRGd2Lgv2EXc95RquglwL+6mYu7ICF2HcT7d5mSrENuOd99LuwV+bXIi6+Ba OCaB0pDcLSbvxcj9KtwkzzipukgAaA/b/bUs7JJRpdBWTaZLXBB5drintYWr00L0j1CpDZfPv lxaRLm0WdIWx4haVvkUvKmQbCmrPL21+TvKq+V9DA39aO2uAohC+BPLHxdRzQIAwlG2EOCPSE WD8c754OK3BRjEIGhxEPrwpOnoJdgEAKzrOcObeEGHE3Hf+A6QhGuKYhzFT7aLlzbL48p4ong Sw5KM0+1Fq7RwBgo1o1jml+Scfxy7VPtCuh6NpnbDIuxesYboaYqOQ2B3WEkhAWj21zgeTb4h /VfYrtPeGwpWadOoPf7EAhwGhukj1OOdRqUJhiad3Vb1a4R+vswQQX3vk+81Wfjo5mv3SH+Sf jU3rVVNKXSp7VVi+/wRJQf0+lm5ngNqL5aLs8+pF3d5ZcoXuaRILBJhEY1k28uSoajIV1mJLD r6ghmgnEEjvH5IUaFLOFnpeUz74i6uGtoRb4gED4umimBJxtcFDm/2UmAEBCD8mHQngnm+Ph3 zZ0KhXrSsmAPugdWBAdlxukHZZhVg0yY0u3A6zV5Apg76FsW6s8J2xMF08n+h+dtxWenMnAy6 pBQNmIokrMIB2yDFgId46miKs8/FV6cGavtWTXCe4uUg3U38za6SDOOB09zVKXJ5PJ3jvctVt EvFbeQnEP0fKpwcAzNcplFAFbuIV2extxpB8N53BlTBHVzvWo7++Ct69//TORhNt6HA9ozBAG 4U7u+4GmNJcq6GPKcHH93ozegXdvvnsgj8t62ri/3X78jngJlin2zinLWJY2XURe2iZ+SbPTC W3IEqfT/x758Lh2OxX4dkKQDdRi70vYH231IQ3HGiRBkCZQTb/oDge0MMwKV2XUG5DpZ326DF 93q3PcTrEcrbe1q9PRhGtPKBQbSdNCmWGcbSHumEOzD/KnVRApN2cDOdSpEKTEJG/P68+eIxx h2rWewfntCe65W5BlTJI9rddhcgpzHPYYvYl2dh+OM/wgtSmlrs+b8lzYkNMuK2JyPvqNpFy+ jHDj0sZ0Z2wy/t0xAInvrM42e+ExeWgYvvG5TnwVxWqfVic/aoKWSK79zLC4CWyE9EVEBjMYL Jb1AP/ZqCM/8XsBSsp8fs7DzqRnJN9IYeqPzgPxkxIoltjY0uctwpOYO0eNT+4kxUZiO/wb/W RB25WNE7HUC25xb44gGiXoUUb/u87zxbtzxqDomknjdo6BcLwA25kHEU5lYeY3UASkMluaoJ+ mVDWfrx3WJ6XGFxENOgPRd9iin3rsqzD7Dyyt2utFdBTtcbt4BsP7WgY5euSFagw5dAkLTU51 KD5hGlbZvzK20OZNPN+2GiKbbCamMwyfuYkJbO7FqC9X3g98PupK82Xv7zWuinaHb7JZXksNl Lr9soFflnC+tfbnQciZxqZn+BFdnmtAbzggqmRgb3ZzKoDzQ2BIL9ulaT3/jb3p0dJEVAaaSD jyxNMgUNI+AnUMqoDx7sUy0GGvFt3rQ1AJBqxTfwFS+LQ2+Hk/EycH4Ugj9OMvOFKF4a7/WWH QwCWEwNWCbPYbyM/M8YotF16wCGw6C5X0GWwmalRiFvmMpRvxp6VSSAW53McJfpM+/1JgGCCQ 6bohEoXXKyfmB0p0NYfq5whKqqs5hE4kiW78RuUSSKFyD1RdUZdrzhHmHwAnhC4IdPFj61Ylz w+xldEo1yYVfDoKaCEGTQoMMIxkJkBcP+qIYalmiENuN4yqDPCEQAzCU0NmQzEGma+faxrWec BZDz/GeHOf6UNXN7Ua8Ru8ovxk7fdoCyJiy7BrKKfnYJUS+IdDpJZKONCAOnB3TeOQq08ZsdX 0XXctiv030H5GNakEuhbuUymLGU3gIT22cB3IJfQUl1VCKWRLlVAetBBBpBXwugQi+nsR+LRP CKITh0rHooQZ+gE/z5qitznqKwIrDDttdspKEbGlhq5pSkmJMHBra5ZpNmrgeaVXytzrdvIly auXEp6OfsD5RZ1C1LetwTCHV/+svgbjSV6UtmBQARKro+jMM+oG0WBKWiD+SdlVtBqxV9DMEX yTC8Km1kjVetJxC0VDx1HQ+a0H8kArjX39u59O9pJ1GbtsEQPI3MaJbGKGa5NjYxVSS+WdZm4 XIJ6QnMVE5cBseqImGqfLqq2foa1wc7FsiU56xxnCMhczTbKKDvHgzH3GKs2sB8SKOETnkdQC Yd+dT9FLS/vUeORzkvV+rP9b7wlKRxfvcTcIXfe0fIbBJiwZ/T3cAhj3YhotV2Dq/W/xkHEcZ hSobXyQeDfS/ugoJ762qgX7Daop7w5a1b5hZbBkN2dJwhQg7RMsVmPneiVQACt/fdW0ix1gWH Cd7KX+aydktqKNpYU2SnV2vyCFa2SkYyKXdPuz5nG/v6pIkIql32oIGwUdgT6E7TOrREKaf85 dmMHmRSq3VdbfPKgMPetgxoa+YNm0wNQ1xZl8GJSCGbPENqQj3C7i2BhQXkB8MFSl250pAb5Z 12xdc5XoQp/pjMB8JnrWfNQbUzJlDts9YKzx47OsVvLxz62B4XtJOr+Ezf2B3DL5DjL+y/x4G JRIWNW2syRBlfv/gbJAAAqhhYfWuSwkruu+mTefYtX6Jan3fNqKVE6Jon5noPTd6+1BbGWW4Z QtQn7AwLhVN4N8DlHm+qmLgZHkCNshUgN04Cd91Kt9WhogKsFc2CU+FLH4XJvaNHLcsY2+HoZ auHaKri+VHGJnDrR4Dl8bZXuwKsKSwTQ2eB0USOceQ5ja0aE8nto6it1biomJKTunEqvmS+5K 2+9IFaXhkOalwUhPuD4PeK3u2fioCttSm4RSukCKdtGq9m8qZf5ZGCchILlItv0A4RjhaWGWn X74P7ZiSgG/m+j29TJfVswkAO+01qvZYRFMhQ6bf81CI6qQwsGOL8QkOTswSpFKx9foN3tYiM 5N7P+3ZYq75B0SMuegt4dLGBU6WHvfMRJE2p1biTHSvdSUlJaZN8JMq3FeAmNIE1pPs+iJ8Wd CKDyU4dYV4BtNBKXOGwqW8YGEFEToDr0feC20jKrm1AULoKA3aqi7x+t9IadsGMOXIeHOCnWM yPbrgWbb3+OkO4iWnm7KqAJj5PGqMDXVA/Nw1xIGCOiqIl9XcxcUv7MlUFudpv8URH3l6jLaL XTArC7DgPn5flI6IGAJthJmX7WFcv0ixcGGM80YZfdxBOgH6jgAAYMtVuKgZGQ2XNylfekXUz Sp/VayClTQ6K3kud7uJBsrYrVs+KRUUXV5ixTtH3JecM8H9YrIE77L1X6b4+4t883GZf7kmYR hL1aLNqz3Cp/dPg8+3FL40BsOAyNPc1RE3TSeQHv/EQiMiVzzXfFkNbr8QZ4LU3KR7hVA0VHB 3laEzU4UVDsLHWvKPba3GHgJlNFtUX3cQKyoj5kVJgfB6g19CfLATBsBpn8IX0f6riQg== 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 06:29:36PM +0200 schrieb Dominique Devienne: > > 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 > Yes and no. Depends what you mean by MEMBER... ... > So I didn't spend time studying your specific use case. That's your job = :). > But given my painful experience of the past year, I'd answer yes to your > question, on logical grounds. If you see what I mean. --DD I followed your posts back then when you worked out your use case so I did have _some_ idea where to look ;-) I just wanted to confirm my understanding in relation to my current usage. David kindly provided the needed affirmation. Regards, Karsten =2D-=20 GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B