Re: drop role with privileges

Tom Darci wrote:
> Hey All-
>
>   It seems like there should be an easily-found answer to this, but if
> there is, I can't find it.
>
>   I am simply trying to drop a role.
>
>   So, before dropping it I need to reassign all its owned objects
> (REASSIGN OWNED, very handy) and then revoke all privilges it has had
> assigned to it. The revoking privileges is the hard part. (And why this
> requirement?) I can (and have been) explicitly revoking all privileges
> on each database object first, but that's a lot of unneccessary work
> (and time... it's done programatically though, of course).

Did you try DROP OWNED BY?  It revokes privileges (as well as dropping
objects owned by said role).

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support