On Wednesday April 4 2007 4:35 pm, Alvaro Herrera wrote: > > Note that you can give the objects owned by that role to > someone else with REASSIGN OWNED, and drop the objects with > DROP OWNED (note that they act differently regarding grants; > see the docs) Yes, but how do identify what they are so that I know if I want to DROP OWNED them? TIA. Ed