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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Connection Pooling - tracking users

Re: Connection Pooling - tracking users

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 6 Jul 2005 08:08:33 -0700
Message-ID: <1120662513.557542.319370@z14g2000cwz.googlegroups.com>


Generally speaking there is no way to trace back to the ultimate end-user for connections made through a connection pool where all the sessions use the same Oracle username and show as the OS user of the webserver or application server unless that information is passed to Oracle by the application. The Oracle package DBMS_APPLICATION_INFO is sometimes used for this purpose.

Possible solutions for this depend on the information Daniel listed.

HTH -- Mark D Powell -- Received on Wed Jul 06 2005 - 10:08:33 CDT

Original text of this message

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