who called my procedure through a database link [message #678135] |
Tue, 12 November 2019 13:18 |
Bill B
Messages: 1971 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.
|
|
|