Postgres Pro
Downloads
Home   >   mailing lists

Re: About revoking large number of privileges; And the PUBLIC role. - Mailing list pgsql-general

From Stephen Frost
Subject Re: About revoking large number of privileges; And the PUBLIC role.
Date
Msg-id 20220715173320.GD9030@tamriel.snowman.net
Whole thread Raw
In response to About revoking large number of privileges; And the PUBLIC role.  (Dominique Devienne <ddevienne@gmail.com>)
List pgsql-general
Tree view 
Greetings,

* Dominique Devienne (ddevienne@gmail.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
Attachment

pgsql-general by date:

Previous
From: Martin Kalcher
Date:
Subject: Proposal to introduce a shuffle function to intarray extension
Next
From: Zsolt Ero
Date:
Subject: could not link file in wal restore lines