Re: privileges

Lisa,

You can query dba_dependencies to see what each object references.

Dennis

"Koivu, Lisa" wrote:

>
>
> I inherited a database and application that was developed using the
> famous 'smear' method of privileges. In other words, everybody has
> access to anything to do whatever they please.
>
> It's time I cleaned this up. I have no guidelines to work from and
> quite honestly don't know the application too well - I have written a
> minute amount of code for this app. I'm thinking I could sift through
> dba_source as a starting point, to see whose procedures are accessing
> stuff outside their schema, etc. Man, this is going to be a big,
> tedious, messy trial-and-error nightmare.
>
> If anyone has done anything similar and has any suggestions I would be
> very happy to hear them.
>
> Thanks
>
> Lisa Rutland Koivu
> Oracle Database Administrator
> Qode.com
> 4850 North State Road 7
> Suite G104
> Fort Lauderdale, FL 33319
>
> V: 954.484.3191, x174
> F: 954.484.2933
> C: 954.658.5849
> http://www.qode.com
>
> "The information contained herein does not express the opinion or
> position of Qode.com and cannot be attributed to or made binding upon
Received on Thu Sep 21 2000 - 16:39:04 CDT