From: devnull50@yahoo.com (Evan)
Newsgroups: comp.databases.oracle
Subject: Re: prefixless Select statement
Date: 8 Aug 2001 06:24:16 -0700
Organization: http://groups.google.com/
Lines: 13
Message-ID: <4009888a.0108080524.62ed19a7@posting.google.com>
References: <d989eaab.0108072342.659d96ec@posting.google.com>
NNTP-Posting-Host: 146.145.252.1
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 997277056 21909 127.0.0.1 (8 Aug 2001 13:24:16 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 8 Aug 2001 13:24:16 GMT


If user USER1 has read privileges on tables created by another user,
login as USER1 and create a synonym.

For example say, ADMIN creates table employee
You problem is when you log in as USER1 you are having to run the
following;
select * from admin.employee;

To resolve, log in as USER1 and create a synonym
create synonym employee for admin.employee;

This will allow you to then type the following:
select * from employee;