How to Pass BOUSER to Application Context in Oracle

[system]

Hi.
I dont know if i have undestood your problem.
But maybe this post will help you:

120×120 10.4 KB

I have tested this technique, using ConnectInit custom parameter in the Universe connection setup to call a “setsecurity” function and passing the bouser variable. I am on a 10G database in a shared/pooled connection environment, with BOE XI R2. In my function, I call sys_context (userenv) fields and write them all to a table so I can view the contents (good for auditing). With several testers querying test reports at the same time, I captured the exact same sessionid/SID which should indicat…

Good luck!

---

Jaimepe (BOB member since 2006-12-10)