Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@apache.org Received: (qmail 68137 invoked from network); 23 May 2003 16:56:18 -0000 Received: from exchange.sun.com (192.18.33.10) by daedalus.apache.org with SMTP; 23 May 2003 16:56:18 -0000 Received: (qmail 3802 invoked by uid 97); 23 May 2003 16:58:30 -0000 Delivered-To: qmlist-jakarta-archive-tomcat-user@nagoya.betaversion.org Received: (qmail 3795 invoked from network); 23 May 2003 16:58:30 -0000 Received: from daedalus.apache.org (HELO apache.org) (208.185.179.12) by nagoya.betaversion.org with SMTP; 23 May 2003 16:58:30 -0000 Received: (qmail 66722 invoked by uid 500); 23 May 2003 16:56:04 -0000 Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Tomcat Users List" Reply-To: "Tomcat Users List" Delivered-To: mailing list tomcat-user@jakarta.apache.org Received: (qmail 66711 invoked from network); 23 May 2003 16:56:04 -0000 Received: from web40708.mail.yahoo.com (66.218.78.165) by daedalus.apache.org with SMTP; 23 May 2003 16:56:04 -0000 Message-ID: <20030523165608.28954.qmail@web40708.mail.yahoo.com> Received: from [64.32.176.246] by web40708.mail.yahoo.com via HTTP; Fri, 23 May 2003 09:56:08 PDT Date: Fri, 23 May 2003 09:56:08 -0700 (PDT) From: Lior Shliechkorn Subject: RE: Question about Connection Pooling and roles To: Tomcat Users List In-Reply-To: <7BBEC00F10E89A4D8134913FA9C4C4962B8560@Pebbles.UH.EDU> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-419974772-1053708968=:26909" X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N --0-419974772-1053708968=:26909 Content-Type: text/plain; charset=us-ascii I'm trying to implement the connection pool with Tomcat though. I set up the JNDI resource, and I want to be sure that I can implement connections that can sometimes write to the database, and connections that can only preview the databse. Thanks. "Prabhakar, Achal" wrote: I am not sure if it is supported by other databases, but in case you are using Oracle you can use proxy connections. The following link shows a sample of how this is done. http://otn.oracle.com/sample_code/tech/java/sqlj_jdbc/files/9i_jdbc/OCIMidAu thSample/SalesRepBean.java.html Regards, -Achal -----Original Message----- From: Lior Shliechkorn [mailto:liorshliech@yahoo.com] Sent: Wednesday, May 21, 2003 3:41 PM To: Tomcat Subject: Question about Connection Pooling and roles Hi everyone, I was curious about JNDI and actual roles users play when accessing the database. If I have a user that logs in and can only view and insert into the database, and then a user that can view, insert, and update tables in the database, what is the best way to go about assigning connections to each user. >From what I've been exposed to, I've seen that some connections, when created for a certain user already have restrictions applied to the user. So do I create two JNDI sources for a user that can get a connection that allows writing to the database, and then one that contains the other restrictions? So one database can pool more admin like connections, and the other can contain restricted connections? Thanks a lot, Lior --------------------------------- Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. --------------------------------------------------------------------- To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: tomcat-user-help@jakarta.apache.org --------------------------------- Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. --0-419974772-1053708968=:26909--