Re: About revoking large number of privileges; And the PUBLIC role.

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Dominique Devienne <ddevienne(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: About revoking large number of privileges; And the PUBLIC role.
Date: 2022-07-15 17:33:20
Message-ID: 20220715173320.GD9030@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

* Dominique Devienne (ddevienne(at)gmail(dot)com) wrote:
> So my goal is to delete all those "db specific" ROLEs, then the DB
> with all its schemas.

If you want to drop the database anyway.. then why not simply do that
first? Nothing can be connected to a DB that's being dropped and we
don't actually try to lock all the objects in a to-be-dropped DB.

Thanks,

Stephen

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Zsolt Ero 2022-07-15 20:11:09 could not link file in wal restore lines
Previous Message Martin Kalcher 2022-07-15 08:36:06 Proposal to introduce a shuffle function to intarray extension