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