[jboss-user] [Beginners Corner] - Re: USERS and ROLES - why in seperate tables?
PeterJ
do-not-reply at jboss.com
Mon Oct 29 18:30:51 EDT 2007
You could put them all in one table, but that breaks some relational database rule (first-normal form?). Usually, if a user has multiple roles, in the Roles table you have one row per role, with each row having user name and role columns. Thus 'select role from roles where user=xxx' actually returns multiple records.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4100029#4100029
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4100029
More information about the jboss-user
mailing list