Re: Scope of tables?

Tom will need to grant select on his table to Sally (or public).

Somebody (anybody with CREATE ANY SYNONYM privilege ) must then create a public synonym for Tom's table so that anybody referencing that synonym will be accessing Tom's table.

HTH Graham

Matthew C. Aycock wrote in message <7fiee8$lp1$1_at_finch.mathcs.emory.edu>...
>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 - 17:03:42 CDT