Database design for user roles with dependencies

Asked Dec 19 '13 at 18:08

Active Dec 19 '13 at 19:38

Viewed 135 times

I have a users table, and each user can have one or more roles (from a total of about five). Depending on the roles, the user will have associations with other tables. For example a trader will have an "account", a manager will have a "company" etc.

How can I model this please?

edited Dec 19 '13 at 19:38

asked Dec 19 '13 at 18:08

pingu

8,719
12
50
84

why don't you use a database with built-in users and roles? – Neil McGuigan Dec 19 '13 at 21:06
Neil - I do not understand. – pingu Dec 20 '13 at 09:53
I'm suggesting you could use built-in database roles and security instead of rolling your own. – Neil McGuigan Dec 20 '13 at 10:38
1

I have no idea what Neil is talking about but [this question](http://stackoverflow.com/questions/425711/preferred-database-design-method-for-assigning-user-roles-hats-vs-groups?rq=1) sounds like yours and it has a good answer. – Benny Hill Dec 20 '13 at 16:49

Database design for user roles with dependencies

0 Answers0