Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: USER_TABLES
:;-))
Svend Jensen <svend.jensenKILLSPAM_at_it.dk> wrote in message news:<3DC84D5A.4050502_at_it.dk>...
> 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 Wed Nov 06 2002 - 05:21:56 CST