Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Capturing 9iAS userid

Capturing 9iAS userid

From: <artmt_at_hotmail.com>
Date: 14 Nov 2005 17:21:59 -0800
Message-ID: <1132017719.275535.278340@g49g2000cwa.googlegroups.com>


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 - 19:21:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US