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

From: "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: About revoking large number of privileges; And the PUBLIC role.
Date: 2022-07-08 09:24:03
Message-ID: 20220708092403.zhlnwgykxmkxf6yk@hjp.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)hjp(dot)at | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"

In response to

Browse pgsql-general by date

  From Date Subject
Next Message ml 2022-07-08 10:47:35 postgresql bug
Previous Message Peter J. Holzer 2022-07-08 09:04:06 Re: Seems to be impossible to set a NULL search_path