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

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: 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:16:11
Message-ID: D1C4B519-67B6-446A-92DF-A33D095FD215@elevated-dev.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2025-07-08 12:26:09 Re: REVOKE ALL ON ALL OBJECTS IN ALL SCHEMAS FROM some_role?
Previous Message Ron Johnson 2025-07-08 11:52:11 REVOKE ALL ON ALL OBJECTS IN ALL SCHEMAS FROM some_role?