hello sior am a web developer using MX studio.. But am intreasted in
database programs..and i will love it if you could take your time to
lecture me on these am also a member of www.ioug.org
Thank you Bolaji
artmt_at_hotmail.com wrote:
> I need to capture all executions of a query which is executed from
> 9iAS.
> Among other things I need to log userid - any userid that ties to an
> individual.
> This query is a part of the jsp application that resides on 9iAS, but
> is managed outside of Portal.
> The query itself lives in the xml file. It uses parameter file for bind
> variables and connections file for the connection string to the target
> db.
> Because the query executes from the app server with a shared db account
> all users connect to the target db with the same oracle user and os
> user. However, each user logs in to 9iAS with his own SSO account.
>
> Is there a way to capture userid on the App Server side so I can pass
> it to the query as a bind variable?
> Alternatively is there a way to query iasdb without explicitly opening
> a connection (I assume all users connecting through SSO get connected
> to iasdb)?
> Any other suggestions?
>
> Thanks
> Art
Received on Mon Nov 14 2005 - 21:35:14 CST
