Try this: http://www.petefinnigan.com/find_all_privs.sql On 12/2/05, Jesse, Rich <Rich.Jesse@xxxxxxxxxxxxxxxxx> wrote: > > Hey all, > > So, I want a query to check if any apps schemas in our 9.2.0.5 DB have > too many or too few sys privs. After a week of background head > scratching, I came up with this: > >