Re: Private synonyms - I'm seeing too much!!

Vladimir M. Zakharychev wrote:

> Well, actually it does. If an object appears in an ALL_* view, this
> means that querying user has at least some privileges on that object
> or some system privilege to access ANY object of this type.

I stand corrected. To see an object, you need to have some kind of priv on it. I'm a bad boy. Are you going to punish me now Vlad? Whips and straps and shiny leather? ;-)

> You are absolutely correct about improper use of these views in
> OP's situation though. :)

Well, first time I've heard a user complaining about having access to too many tables and views. :-)

--
Billy