RE: (re): grant question / April's Book

From: Barbara Baker <barbarabbaker_at_yahoo.com>
Date: Mon, 2 Aug 2004 08:17:06 -0700 (PDT)
Message-ID: <20040802151706.59514.qmail@web50608.mail.yahoo.com>

Yes, yes, yes!
This is exactly the kind of "thinking a bit outside the box" that gets a really good dba through the day. I rememeber using a similar trick as a work-around in the past, but still did not think about this technique when the question came up.

April, this is the kind of thing I think would be useful in your book.

Barb

"Mercadante, Thomas F" <thomas.mercadante_at_labor.state.ny.us> wrote:

> 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
>

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 - 10:13:47 CDT