Re: Show Owner of Table

On Jan 24, 1:06 pm, "EdStevens" <quetico_..._at_yahoo.com> wrote:
> On Jan 24, 11:17 am, "rios" <r..._at_rios.com> wrote:
>
> > I'm user "BLAH"
>
> > table "emp" belongs to "scott"
> > I define a synonym "emp" for scott.emp
>
> > When SELECTing from "emp" -
> > blah_at_dev> SELECT * FROM emp ;
>
> > How can I show the owner of the table ("scott") ?
>
> > thanks
>
> > 10gR2Take a look at
> - dba_synonyms
> - all_synonyms
> - user_synonyms

Maybe the following article on where to find information on Oracle objects will help:

How do I find information about a database object: table, index, constraint, view, etc... in Oracle ?
http://www.jlcomp.demon.co.uk/faq/object_info.html

HTH -- Mark D Powell -- Received on Wed Jan 24 2007 - 19:49:33 CST