Re: Show Owner of Table

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
>
> 10gR2

Take a look at

- dba_synonyms
- all_synonyms
- user_synonyms