Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter J. Holzer
Subject Re: About revoking large number of privileges; And the PUBLIC role.
Date
Msg-id 20220708092403.zhlnwgykxmkxf6yk@hjp.at
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 
On 2022-07-07 09:47:38 +0200, Dominique Devienne wrote:
> Hi. I'm struggling to delete databases because of grants to roles on
> objects of those DBs.

I don't understand this. You can drop objects (and databases containing
objects) with grants to existing roles. It would be very inconvenient if
that wasn't possible.

Do you have an example on where a grant prevents dropping an object?

        hp

--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"
Attachment

pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: Seems to be impossible to set a NULL search_path
Next
From: ml@ft-c.de
Date:
Subject: postgresql bug