RE: (re): stupid grant question

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Mon, 2 Aug 2004 10:55:35 -0400
Message-ID: <DE8A21F8F1D0254EA4A9214D52AB2FED11F2C01D@exchsen0a1ma>

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_at_comcast.net [mailto:ryan.gaffuri_at_comcast.net] Sent: Monday, August 02, 2004 10:47 AM
To: oracle-l_at_freelists.org
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_at_freelists.org
> 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_at_freelists.org 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_at_freelists.org
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
-----------------------------------------------------------------

Received on Mon Aug 02 2004 - 09:52:17 CDT