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
