| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: To Anyone involved in Web apps
Regina - This is an issue we've just been struggling with. The first
question is how your users are accessing the database? In our case it is an
application server, Weblogic. Now most app. servers are capable of
performing connection pooling, so if all the connections connect to the same
Oracle userid, the connection pooling can perform most efficiently. In this
case, the Java programs being served by the app. server will be performing
the security.
Now, if you are using other web tools that don't use connection pooling and may not have as much security themselves, then the answer may be different.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Tuesday, January 21, 2003 1:41 PM
To: Multiple recipients of list ORACLE-L
Hi
I have a question for any of you involved in Web applications. I would like to know how many of you go for the single Oracle user for everyone approach, and how many of you create Oracle schemas for each user, and if you can, what was the major reason for choosing that approach. Any opinions you wish to contribute will be helpful.
Thank you,
Regina
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Regina Harter
INET: rharter_at_emc-inc.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).
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). Received on Tue Jan 21 2003 - 14:14:23 CST
 |
 |