Home » SQL & PL/SQL » SQL & PL/SQL » who called my procedure through a database link (Oracle 10g)
icon5.gif  who called my procedure through a database link [message #678135] Tue, 12 November 2019 13:18 Go to previous message
Bill B
Messages: 1927
Registered: December 2004
Senior Member
I have a procedure sitting in a schema with definer rights and I only want it to be able to be run from the XYZ user who is accessing the procedure through a database link. The procedure is not in the schema that is being connected to through the database link. I have checked everywhere I can think of and I haven't found anything. I want the information directly from oracle so the calling user can't be faked by passing a password or something like that. Anyone have any ideas. Just a little background. The database link is going into a read only schema. The procedure works just fine using definer rights but I want to lock it down so only the specific user can call it.
 
Read Message icon5.gif
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: problem to show result in join tables
Next Topic: Return TYpe (tablet) as output parameters.
Goto Forum:
  


Current Time: Tue Jan 28 13:42:12 CST 2020