----- Original Message -----
Sent: Friday, April 05, 2002 11:15
PM
Subject: very interesting problem with
V$SESSION and web applications....
Dear Gurus , I have a comic question .
?
We have a db and ias and portal . users log in by
using portal login page .
The problem is : because application server
connects to db , in v$session the machines are all the application server
machine .
Although the users are db users , when you login
from portal , the usernames are portal30 and portal30_sso ..
So how will I know which user is which session ?
V$session gives no help ...
May be comic :) But can not find an answer ..
Investigating portal for writing into v$session as the real username ..But no
other thing comes into my mind ....
Any idea please ...
Bunyamin K.
Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S.
Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 /
1217
Mobile : +90 535 3357729
The degree of normality in a database
is
inversely proportional to that of its
DBA.
