Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Query to check schema sys privs

Re: Query to check schema sys privs

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 2 Dec 2005 20:22:16 +0000
Message-ID: <bf46380512021222h7151715fj234313460d85a985@mail.gmail.com>


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-l
Received on Fri Dec 02 2005 - 14:24:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US