FreeLists / oracle-l / RE: (re): stupid grant question

["Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>]

Ryan,

For gathering stats, what I do is to create a database package that performs
the gather_stats command.  I can then grant execute access of that package
to the specific user.  Works like a charm for me.  I even thru some simple
security into the picture to control what tables they may gather stats on.
The package also allows users to drop and recreate indexes.

Let me know if you'd like a copy of the package.  It's pretty simple.

Tom Mercadante
Oracle Certified Professional


-----Original Message-----
From: ryan.gaffuri@xxxxxxxxxxx [mailto:ryan.gaffuri@xxxxxxxxxxx] 
Sent: Monday, August 02, 2004 10:47 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: (re): stupid grant question


anyway to do this without using an 'any' grant. not allowed to use those
here... we have a big thick document that says what we can and cannot do.
That is a big no, no. 
-------------- Original message -------------- 

> I believe you need ANALYZE ANY for DBMS_STATS outside of your schema.
> 
> --
> Niall Litchfield 
> Oracle DBA 
> http://www.niall.litchfield.dial.pipex.com 
> ---------------------------------------------------------------- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> ---------------------------------------------------------------- 
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx 
> put 'unsubscribe' in the subject line. 
> -- 
> Archives are at http://www.freelists.org/archives/oracle-l/ 
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html 
> ----------------------------------------------------------------- 

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------