Dennis Thanks for the reply. Currently I have available versions 8.1.7 on Win 2000 and Sun Solaris, but soon I may get 9i (9.2.0.1) installed.
Witold -----Original Message----- WILLIAMS Sent: 21 January 2003 12:00 PM To: Multiple recipients of list ORACLE-L Witold - You didn't say which Oracle version you are on, but you may want to look at "application role", "secure application role", "global application context". Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Tuesday, January 21, 2003 7:04 AM To: Multiple recipients of list ORACLE-L Hi all I wonder if an application can use an already opened connection but pass credentials of the application user? I would like to use a connection pool to increase performance of my application by reducing opening and closing DB connections. So when my application server starts up it would open let say 10 connections connecting as APP_USER user. Then when user JDOE runs my application, the application would use one of the already opened connections, but Oracle would know that it should use JDOE's rights and any changes, also saved in an audit tables, would be made as JDOE. Of course JDOE would also be a database user but the application would not have to open new connection for JDOE. I have done it differently - open connections as APP_USER and when JDOE starts the application, I use one of the APP_USER's connections to verify that JDOE is a valid user, but then use the APP_USER's connection to run queries, make changes etc. Can, what I am looking for, be done? If yes, could you pass references to some info? Thanks Witold -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).