Home » SQL & PL/SQL » SQL & PL/SQL » About the invoker privilege (Oracle 9i)
About the invoker privilege [message #391796] Fri, 13 March 2009 09:30 Go to next message
ywz65567
Messages: 1
Registered: March 2009
Junior Member
I have created procedure which called A by user B, and then user C wants to execute this procedure. If C just use: execute A, then error happened, error message is "A is not declared". But if we execute B.A, then it works. Do you have any good idea to solve this problem? I just want to call this procedure directly. I don't want to add the owner in front of the procedure name.

Really appreciate if you can help me.
Re: About the invoker privilege [message #391797 is a reply to message #391796] Fri, 13 March 2009 09:32 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
It could by solved by SYNONYM
Re: About the invoker privilege [message #391799 is a reply to message #391796] Fri, 13 March 2009 09:58 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You could use ALTER SESSION SET CURRENT_SCHEMA = B
Previous Topic: Date and Time comparison query - HELP (2 threads merged by bb)
Next Topic: Primary Key Creation on a Large Table
Goto Forum:
  


Current Time: Thu Dec 08 22:00:33 CST 2016

Total time taken to generate the page: 0.09149 seconds