Re: Scope of tables?

Matthew,

Welcome to the world of Synonyms.

The command you want is:

CREATE [PUBLIC] SYNONYM synonym FOR schema.object

where object is either your table or a view of the table.

Good luck.

Patrick Suppes

"Matthew C. Aycock" wrote:

> I am new to the oracle way of doing things. I have a LITTLE experience with
> Sybase on Solaris/sparc, but I am planning on migrating over to the
> new Oracle 8i server I just installed.
>
> I have a user who created some tables. I would like another user to be
> able to refer to those tables without the need for specifying the owner.
> For example, Tom creates table x. I would like Sally to be able to do
> a select * from x instead of select * from Tom.x. I thought this would
> have been done via the TableSpace, but both Tom and Sally are in the default
> USER tablespace.
>
> Any help would be appreciated.
>
> Thanks,
>
> Matthew
> ----------
> Matthew C. Aycock
> Operating Systems Analyst/Admin, Senior
> Dept Math/CS
> Emory University, Atlanta, GA
> Internet: matt_at_mathcs.emory.edu
Received on Tue Apr 20 1999 - 13:05:04 CDT