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 1uZ7FP-00GKIi-3v for pgsql-admin@arkaria.postgresql.org; Tue, 08 Jul 2025 12:16:31 +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 1uZ7FN-007YCC-45 for pgsql-admin@arkaria.postgresql.org; Tue, 08 Jul 2025 12:16:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uZ7FM-007YC4-PU for pgsql-admin@lists.postgresql.org; Tue, 08 Jul 2025 12:16:29 +0000 Received: from mailout.easymail.ca ([64.68.200.34]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uZ7FK-006S2X-1Q for pgsql-admin@lists.postgresql.org; Tue, 08 Jul 2025 12:16:29 +0000 Received: from localhost (localhost [127.0.0.1]) by mailout.easymail.ca (Postfix) with ESMTP id 098B7DFEDD; Tue, 8 Jul 2025 12:16:23 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1751976983; bh=VVfD+oPTnPOdwgH2tZY5jdRcoQ8YbaX/HEs5JDkkv9s=; h=Subject:From:In-Reply-To:Date:Cc:References:To:From; b=hVQGI+QZ4pz0vGQZSiF5zn6TVjWMMGwIyzPG27ZnukU7TAediBIGsrU7eIDU6Y4Nz +/9j25q1sRD+5oscRuwExsdJNwJkMAtJweknx4VL8Dpi4//vm1UG8ZZE8UPw8dDkLD Xq660/2tb6IePp9RsIrICSckoUMPEQShyPbIex6doB7y0JpZAaz+EVdcPt72moDSGz OB9rYhbzynAMtXg1LfSzsOs8HTE+Z419HQxb44tRgQs99wdwMQaOksRs8GA4zx5XbO 8yzFH3KfzbMETvoFuJ5jgWNYriQvjUfLXgVRthgeqtnbN+lsl5QPDSUygJXdxzCixe WwYyIqi6t7SAA== X-Virus-Scanned: Debian amavisd-new at emo08-pco.easydns.vpn Received: from mailout.easymail.ca ([127.0.0.1]) by localhost (emo08-pco.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id f-RYgYQ3QbMJ; Tue, 8 Jul 2025 12:16:22 +0000 (UTC) Received: from smtpclient.apple (165.140.184.195.ip.vcn.com [165.140.184.195]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mailout.easymail.ca (Postfix) with ESMTPSA id 6C645DFDE5; Tue, 8 Jul 2025 12:16:22 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1751976982; bh=VVfD+oPTnPOdwgH2tZY5jdRcoQ8YbaX/HEs5JDkkv9s=; h=Subject:From:In-Reply-To:Date:Cc:References:To:From; b=H3iU9gO7PYvqqthkGKDYrYWxQcqSaHG3xnb+dGObUoBHLmJ8Ellng1rsr5oJUliom QaWMPLZW7NfQDURGegShamCi0xJeCUJVJ9BPL6k7QCeNFb9eSH2Yiwv8/5yUUVMBfW P7BftUW/tZDqEUNvPoPFsTrc4lTOMlzZ2fGkg+RYMBX6TiOtkxvu6D0Xx5UA701QDP SelTqPGik90uhwwpXz0r+hpJkb3qJIgPsbXg81/Wc2tuG4GA7Mzj8USxESQ5bQ2DwY glIrPdTi19ukwI02IJVQBbs2sOnv14dOj1K+lOdYbIRxqSJoWWescyE8DtrIGYZem2 PJ2YeBd4p4oAg== Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.600.51.1.1\)) Subject: Re: REVOKE ALL ON ALL OBJECTS IN ALL SCHEMAS FROM some_role? From: Scott Ribe In-Reply-To: Date: Tue, 8 Jul 2025 06:16:11 -0600 Cc: Pgsql-admin Content-Transfer-Encoding: quoted-printable Message-Id: References: To: Ron Johnson X-Mailer: Apple Mail (2.3826.600.51.1.1) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk I don't have an answer for you, just a question out of curiosity. Is = this a prelude to dropping the role? Thus, if it existed, DROP ROLE ... = CASCADE would have worked for your use case? (Even so, I could still see other uses for your request.)=