Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Show Owner of Table

Show Owner of Table

From: rios <rios_at_rios.com>
Date: Wed, 24 Jan 2007 12:17:59 -0500
Message-ID: <12rf56910q5ref3@corp.supernews.com>


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 Received on Wed Jan 24 2007 - 11:17:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US