Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Query to check schema sys privs
Try this: http://www.petefinnigan.com/find_all_privs.sql
On 12/2/05, Jesse, Rich <Rich.Jesse_at_quadtechworld.com> 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:
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Dec 02 2005 - 14:24:31 CST
![]() |
![]() |