Re: USER_TABLES

Brian Everett wrote:

> In a procedure I need to have a list of tables from another schema.
> Can I be given rights to view someone else's USER views?
>
> If I am in Bob schema and I want to see a list of tables owned by Fred
> in his schema could
> I look at SELECT TABLE_NAMES FROM FRED.USER_TABLES with the correct
> grant ?

No

>
> Currently, if I am Bob I can do a DESC FRED.USER_TABLES and get a
> proper return.
>

No

> Note: I need this question answered. I don't require an alternative.

Got it

>
> Thanks,
>
> Brian
>
>
Received on Tue Nov 05 2002 - 16:59:38 CST