On Mon, Dec 15, 2014 at 9:43 AM, Marko Tiikkaja <marko(at)joh(dot)to> wrote:
> Hi,
>
> This week I had a problem where I wanted to drop only the privileges a
> certain role had in the system, while keeping all the objects. I couldn't
> figure out a reasonable way to do that, so I've attached a patch for this to
> this email. Please consider it for inclusion into 9.5. The syntax is:
>
> DROP PRIVILEGES OWNED BY role [, ...]
>
> I at some point decided to implement it as a new command instead of changing
> DropOwnedStmt, and I think that might have been a mistake. It might have
> made more sense to instead teach DROP OWNED to accept a specification of
> which things to drop. But the proposal is more important than such details,
> I think.
You should consider adding it to the upcoming CF:
https://commitfest.postgresql.org/action/commitfest_view?id=25
Regards,
--
Michael