Topic: Database Administration >> acces tables without prefix
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: acces tables without prefix |
| fireit |
Posted: Apr 14, 2008 01:11:10 PM |
Total Post: 23
Joined: Apr, 2007
|
hi.
i want users of my database to access tables of the user "gab" without prefix. for example, i don't want them to write "select * from gab.emp".
i want them to write "select * from emp". |
|
|
 Mohammed Taj |
| Posted: Apr 15, 2008 01:21:27 AM |  |
|
Total Post: 694
Joined: Jul, 2007
|
There is one solution for this.
SYNONYM.
create synonym for gap.emp table
|
|
|
|
|
| fireit |
| Posted: Apr 15, 2008 04:53:38 AM | |
|
Total Post: 23
Joined: Apr, 2007
|
can i use user context to solve this problem?
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 242 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
