Alternatively, Create a view (Access query) to handle roles, then you don't need that superfluous column in your user table and you can modify your view at a later stage to handle additional roles.
eg. create a query with the sql SELECT Username, "DEFAULT" from usertable At some later stage change query to SELECT Username, "DEFAULT" from user table union all select username, realrole from role table (with appropriate joins between user table and role table) I'm not 100% sure that you will be able to use this with the JDBC realm, but I'd be very surprised as it is fairly simple internally and should just select the data out. Almost as simple, and far more flexible. Geoff Peters wrote: >See THAT is why I subscribe to this list - easy solutions right under my nose, but >someone else can think of them quicker! > >Thanks, that should do the job perfectly, even though it is Access 97 (yuck) > >Thanks again, Geoff > > >-----Original Message----- >From: Barney Hamish [mailto:[EMAIL PROTECTED]] >Sent: June 4, 2002 8:47 AM >To: 'Tomcat Users List' >Subject: RE: Bypassing user role assignment??? > > >Why don't you set the user roles table to be the same as the users table. >Have a user_role field in the users table with a default value "default >role" or something. That way when you create a new user a role is >automatically created for them with the role of "default role". Then you >don't have to change anything or rewrite the hasRole() method. > >-----Original Message----- >From: Geoff Peters [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, June 04, 2002 1:36 PM >To: Tomcat Users List >Subject: RE: Bypassing user role assignment??? > > >So it isn't possible to set a default role for everyone at login with a >parameter in the web.xml file? > >-----Original Message----- >From: Ralph Einfeldt [mailto:[EMAIL PROTECTED]] >Sent: June 4, 2002 8:34 AM >To: Tomcat Users List >Subject: AW: Bypassing user role assignment??? > > >The only way I see, is to create your own realm by >extending JDBC Realm and overriding the hasRole() >method. > > > >>-----Ursprüngliche Nachricht----- >>Von: Geoff Peters [mailto:[EMAIL PROTECTED]] >>Gesendet: Dienstag, 4. Juni 2002 13:19 >>An: [EMAIL PROTECTED] >>Betreff: Bypassing user role assignment??? >> >> >>Does anyone know if it is possible to bypass the requirement >>to have user roles defined within a table in the JDBC Realm? >>Reason being is that I have an app where all users need to be >>"standard", and I have scripts and other apps creating the >>users, therefore bypassing the user role definition would >>save me from having to edit these other scripts and processes >>(which are not Java based......) >> >> > >-- >To unsubscribe, e-mail: ><mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: ><mailto:[EMAIL PROTECTED]> > > >-- >To unsubscribe, e-mail: ><mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: ><mailto:[EMAIL PROTECTED]> > >-- >To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > >-- >To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>