User Table With Multiple User Roles RRS feed

  • Question

  • User1928065626 posted

    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.

    Saturday, February 20, 2016 2:33 AM