Re: prefixless Select statement

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; Received on Wed Aug 08 2001 - 15:24:16 CEST