I had the same issue and from what I could find, you had to stick to using a text field.
I ended up writing my own security system that was just an extension off of the ideas supported by Struts. It only takes a few hours to do.. Just put a User "bean" in the session when the person logs on and then write your own isUserInRole() tag to check the bean in memory... Pretty simple... ----- Original Message ----- From: "Dan Allen" <[EMAIL PROTECTED]> To: "Struts-User List" <[EMAIL PROTECTED]> Sent: Sunday, March 09, 2003 2:14 PM Subject: [OT] JDBCRealm question > This is a simple one, pardon the request for advice. > > In the specs for JDBCRealm it talks about a username column being in > the users table and in the user_role table. Does this mean that the > username column has to be the primary key in the users table and not > a user_id?? I thought it was bad design to make a text field a > primary key since it means that it would have to be updated in two > places if the user changed usernames, or are we sticking with the > requirment that users can't change usernames or that it is an > uncommon task? > > Dan > > -- > - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > Daniel Allen, <[EMAIL PROTECTED]> > http://www.mojavelinux.com/ > - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > [Frodo]: "He deserves death." > [Gandalf]: "Deserves it! I daresay he does. Many that live > deserve death. And some that die deserve life. Can you give > it to them? Then do not be too eager to deal out death in > judgement. For even the very wise cannot see all ends." > - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

