Last post Feb 20, 2016 03:08 AM by ninianne98
Feb 20, 2016 02:33 AM|madjester|LINK
Hi all, how should I create a user table that stores user info such as username, password, role, contact, etc.? My focus is on the Role column where a user belongs to more than one role. I have seen people put multiple roles in the role column separated
by commas for users who belong to multiple roles.
My question is, is that the most efficient and scalable way to design the database table to store users' roles? Please show a better solution if you know of one, thanks in advance.
Feb 20, 2016 03:08 AM|ninianne98|LINK
sql membership provider or the new
MVC OWIN security provider. they each both already handle hashing of passwords, storage of email address, and support role management.