Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Capturing 9iAS userid
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
![]() |
![]() |