Hi Vic, Thanks for the lead. Though what is the name of the project? Is it "basicportal"? I couldn't find it on sourceforge. Would you be able to provide me a URL?
Thanks, Mete --- Jakarta Tomcat Newsgroup <[EMAIL PROTECTED]> wrote: > 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]> > __________________________________________________ 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]>
