Home » SQL & PL/SQL » SQL & PL/SQL » map the oracle user name
map the oracle user name [message #266023] Sun, 09 September 2007 01:00 Go to next message
rushing
Messages: 135
Registered: January 2004
Location: Beijing,China
Senior Member
There is a user in oracle 10g , whose name is eng.
If other user (msg) visit its storage procedure , such as func1(), we should write like this :

eng.func1

Now I want to use the procedure directly.
How to map the procedure to this user whose name is msg?
Thanks a lot!
Re: map the oracle user name [message #266024 is a reply to message #266023] Sun, 09 September 2007 01:04 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Use synonym.
Re: map the oracle user name [message #266026 is a reply to message #266024] Sun, 09 September 2007 01:27 Go to previous message
rushing
Messages: 135
Registered: January 2004
Location: Beijing,China
Senior Member
thanks
Previous Topic: Purchased Items summary
Next Topic: how to compare two schemas and get all tables that are not in other schema
Goto Forum:
  


Current Time: Fri Dec 09 13:52:02 CST 2016

Total time taken to generate the page: 0.10599 seconds