Re: REVOKE ALL ON ALL OBJECTS IN ALL SCHEMAS FROM some_role?

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: REVOKE ALL ON ALL OBJECTS IN ALL SCHEMAS FROM some_role?
Date: 2025-07-08 12:26:09
Message-ID: CANzqJaA4-yAWLm_+My4qKd_guCmVFbmfrX5-7ObQ=F_oAz+yoA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

https://www.postgresql.org/docs/17/sql-droprole.html
(1) I don't see CASCADE as an option to DROP ROLE.
(2) CASCADE without a DRY RUN option scares me. Yes, I could put it in a
transaction block, but accidents happen, and rollback could take a
long time.

On Tue, Jul 8, 2025 at 8:16 AM Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
wrote:

> 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.)

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2025-07-08 12:35:00 Re: REVOKE ALL ON ALL OBJECTS IN ALL SCHEMAS FROM some_role?
Previous Message Scott Ribe 2025-07-08 12:16:11 Re: REVOKE ALL ON ALL OBJECTS IN ALL SCHEMAS FROM some_role?