Return-Path: Delivered-To: apmail-jakarta-tomcat-dev-archive@apache.org Received: (qmail 46549 invoked from network); 5 Mar 2002 19:45:55 -0000 Received: from unknown (HELO nagoya.betaversion.org) (192.18.49.131) by daedalus.apache.org with SMTP; 5 Mar 2002 19:45:55 -0000 Received: (qmail 11963 invoked by uid 97); 5 Mar 2002 19:45:49 -0000 Delivered-To: qmlist-jakarta-archive-tomcat-dev@jakarta.apache.org Received: (qmail 11920 invoked by uid 97); 5 Mar 2002 19:45:48 -0000 Mailing-List: contact tomcat-dev-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Tomcat Developers List" Reply-To: "Tomcat Developers List" Delivered-To: mailing list tomcat-dev@jakarta.apache.org Received: (qmail 11909 invoked from network); 5 Mar 2002 19:45:48 -0000 Message-ID: <80F5674514B4D311BAFC0040F6A45EEE243670@ntserver> From: "Ignacio J. Ortega" To: 'Tomcat Developers List' , "'john.gregg@techarch.com'" Subject: RE: [PATCH] change JDBCRealm to add flexibility in table layout Date: Tue, 5 Mar 2002 20:43:07 +0100 X-Priority: 3 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.0.1457.3) Content-Type: text/plain X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N > De: John Gregg [mailto:john.gregg@techarch.com] > Enviado el: martes 5 de marzo de 2002 20:11 > I don't see how views will solve this problem. I'm not so > much concerned > with reading user and role data as I am with updating it. > Somehow the two > tables need to be linked by some common identifier. The ( Syntax aproximated maybe sql-92, more or less ) create table users ( user_id integer not null primary key, user_name varchar(15) not null , user_pass varchar(15) not null ); create table user_roles ( role_id integer not null primary key, user_id integer not null, role_name varchar(15) not null ); create view user_roles_jdbcrealm as select u.user_name,ur.role_name from user_roles ur join users u on (ur.user_id=u.user_id) and use this view in jdbcrealm.. Please add what you need to be able to understand you.. Saludos , Ignacio J. Ortega -- To unsubscribe, e-mail: For additional commands, e-mail: