Re: very interesting problem with V$SESSION and web applications....

2002-04-08 Thread Yechiel Adar 



Hello Bunyamin

We have the same problem.
I think that you can solve it with LDAP and 
enterprise users.

Yechiel Adar
Mehish

  - Original Message - 
  From: 
  Bunyamin K. Karadeniz 
  To: Multiple recipients of list ORACLE-L 
  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 / DeveloperCivilian IT DepartmentHavelsan A.S. 
  Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 
  1217Mobile : +90 535 3357729
  
  The degree of normality in a database is 
  inversely proportional to that of its 
DBA.

very interesting problem with V$SESSION and web applications....

2002-04-05 Thread Bunyamin K. Karadeniz 



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 / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 
7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 
3357729

The degree of normality in a database is 
inversely proportional to that of its DBA.

RE: very interesting problem with V$SESSION and web applications.

2002-04-05 Thread Paul . Parker 



Assuming that the application "knows" the real username, let the first 
thing that the app does is call dbms_application_info.set_client_info passing 
the real username as a parameter. This sets v$session.client_info to the 
real username. 

T10-PARTS select client_info from v$session 2 where 
sid = (select sid from v$mystat where rownum = 1) ;

CLIENT_INFO

T10-PARTS execute 
dbms_application_info.set_client_info('REAL_USER_NAME');

PL/SQL procedure successfully 
completed.

T10-PARTS select client_info from 
v$session 2 where sid = (select sid from v$mystat where rownum = 
1) ;

CLIENT_INFOREAL_USER_NAME

T10-PARTS select 
userenv('CLIENT_INFO') from dual;

USERENV('CLIENT_INFO')REAL_USER_NAME

T10-PARTS select 
sys_context('userenv', 'client_info') from dual;

SYS_CONTEXT('USERENV','CLIENT_INFO')REAL_USER_NAME


Hope this helps

Paul-Original Message-From: 
Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: Friday, 
April 05, 2002 4:16 PMTo: Multiple recipients of list 
ORACLE-LSubject: 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 / DeveloperCivilian IT DepartmentHavelsan A.S. 
  Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 
  1217Mobile : +90 535 3357729
  
  The degree of normality in a database is 
  inversely proportional to that of its 
DBA.

Re: very interesting problem with V$SESSION and web applications.

2002-04-05 Thread Bunyamin K. Karadeniz 




  ThANK YOU SO MUCH 
  . ...
  I will enter this code to login code of portal 
  and test it. thank you again .
  
  
  
  
  
  
  
  
  Assuming that the application "knows" the real username, let the first 
  thing that the app does is call dbms_application_info.set_client_info passing 
  the real username as a parameter. This sets v$session.client_info to the 
  real username. 
  
  T10-PARTS select client_info from v$session 2 where 
  sid = (select sid from v$mystat where rownum = 1) ;
  
  CLIENT_INFO
  
  T10-PARTS execute 
  dbms_application_info.set_client_info('REAL_USER_NAME');
  
  PL/SQL procedure successfully 
  completed.
  
  T10-PARTS select client_info 
  from v$session 2 where sid = (select sid from v$mystat where 
  rownum = 1) ;
  
  CLIENT_INFOREAL_USER_NAME
  
  T10-PARTS select 
  userenv('CLIENT_INFO') from dual;
  
  USERENV('CLIENT_INFO')REAL_USER_NAME
  
  T10-PARTS select 
  sys_context('userenv', 'client_info') from dual;
  
  SYS_CONTEXT('USERENV','CLIENT_INFO')REAL_USER_NAME
  
  
  Hope this helps
  
  Paul-Original Message-From: 
  Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: 
  Friday, April 05, 2002 4:16 PMTo: Multiple recipients of list 
  ORACLE-LSubject: 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 / DeveloperCivilian IT DepartmentHavelsan A.S. 
Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 
1217Mobile : +90 535 3357729

The degree of normality in a database is 
inversely proportional to that of its 
DBA.