RE: (re): grant question / April's Book
- From: Barbara Baker <barbarabbaker@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 2 Aug 2004 08:17:06 -0700 (PDT)
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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
- » RE: (re): grant question / April's Book
