Subject: Re: JDBCRealm Question From: "Vic C." <[EMAIL PROTECTED]> === Working sample showing JDBC relms and user table CRUD with SQL (in a single table like you want) is on sourceforge.com basicportal project. (It also has Struts MVC with JSTL)
Vic Mete Kural wrote: > Hello, > > My question is about how the user roles are > deterermined in JDBCRealm. In the basic XML file > configuration, the XML files has an element "roles". > All of the user's roles are provided in this element > as a comma-seperated list. It seems to me that in > JDBCRealm, this is not the case. User_role column of > the User_Roles table only stores one user role at a > time. For instance if somebody has both the roles > "user" and "admin", in the XML file this would be > specified as "user, admin" inside the roles element. > My understanding is that in JDBCRealm, you have to > enter multiple records relating to the same user, i.e. > username for each role that the user has. Is there a > way to tweak JDBCRealm to read one comma-seperated > list string from only one row instead of reading a row > for each role that the user has. > > Why did I need this kind of functionality? Because I > want to keep my user data including the user role all > in one table and not deal with a seperate table for > user_roles. Is what I want possible? Or do you have a > suggestion on how to manage my user_roles data in the > relational database? > > Thanks, > Mete Kural > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Health - Feel better, live better > http://health.yahoo.com > > -- > 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]>
