Isacc is correct, use public synonyms. That is the way for any/every user in an Oracle database to refer to the same table in your "MAIN" schema with having to specify the schema name.
For example, if your MIAN schema has a table named: customers,
The syntax is simply:
create public synonym customers for main.customers;
Then any user in the database can refer to that table simply as: customers. Note that synonyms (whether public or private) do not replace or supercede grants. Each user will still have to granted the rights they need on that table by MAIN, either directly or via roles.
Main Topics
Browse All Topics





by: issacmjPosted on 2005-02-01 at 09:33:33ID: 13194958
Create PUBLIC SYNONYMS for the tables..