On Mon, Dec 15, 2014 at 9:43 AM, Marko Tiikkaja <ma...@joh.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
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
