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


Oracle LazyDBA home page