FreeLists / oracle-l / RE: (re): grant question / April's Book

[Barbara Baker <barbarabbaker@xxxxxxxxx>]

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