Oracle-L: RE: Using connection of another user

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Tue, 21 Jan 2003 07:59:55 -0800
Message-ID: <F001.0053600B.20030121075955@fatcity.com>

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.
dwilliams_at_lifetouch.com

-----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: wiwaniec_at_novalistech.com

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: ListGuru_at_fatcity.com (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: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------