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: seeking help for desired output
Next Topic: Trigger
Goto Forum:
  


Current Time: Sun Aug 20 16:17:09 CDT 2017

Total time taken to generate the page: 0.09341 seconds