Request a Demo
Home   >   mailing lists

Re: REVOKE ALL ON ALL OBJECTS IN ALL SCHEMAS FROM some_role? - Mailing list pgsql-admin

From Ron Johnson
Subject Re: REVOKE ALL ON ALL OBJECTS IN ALL SCHEMAS FROM some_role?
Date
Msg-id CANzqJaA4-yAWLm_+My4qKd_guCmVFbmfrX5-7ObQ=F_oAz+yoA@mail.gmail.com
Whole thread Raw
In response to Re: REVOKE ALL ON ALL OBJECTS IN ALL SCHEMAS FROM some_role?  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Tree view

(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@elevated-dev.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!

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: REVOKE ALL ON ALL OBJECTS IN ALL SCHEMAS FROM some_role?
Next
From: Scott Ribe
Date:
Subject: Re: REVOKE ALL ON ALL OBJECTS IN ALL SCHEMAS FROM some_role?