You can use private or public synoyms to accomplish this.

-----Original Message-----
From: Hefington Monica
[mailto:oracledba-ezmlmshield-x96370133.[Email address protected]
Sent: Friday, June 03, 2005 2:31 PM
To: LazyDBA Discussion
Subject: Granting a user access to anothers schema


I have user1 which has its own schema with tables and views. Some of
these views use database links to other databases on different systems.

User2 wants read access to user1's schema.

Is there anyway to do this that will NOT force users to enter the
schema.table and just the table.

Example:
If I
1. grant select to user.table1
2. create a role with the select access to user1.table1 3. allow public
select access to user.table1

user2 still has to type "select * from user1.table1"

What I would like is:

user2 types "select * from table1"

Is this possible?

Monica



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html



--
This message has been scanned for viruses and dangerous content by
MailScanner, and is believed to be clean.

Douglas County, Oregon
www.co.douglas.or.us


Oracle LazyDBA home page