Timeline for Role based Database Schema
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 11, 2017 at 15:45 | comment | added | Christophe | Suppose you don't implement the second point. You'll have role such as "staff" and "intern". You'll have permissions such as "public", "private", but also role based permission such as "staff only" and "intern only". So you must have an optional relation between DocumentPermission and UserRoles. You could implement this using an nullable column in DocumentPermission containing the id of the related role (implies that one such permission gives access to one role). If you implement the second point, you'll not need this, because the many to many relation allows to define it also. | |
| Jun 11, 2017 at 15:16 | comment | added | ss_millionaire | Thanks. and sorry for the late acknowledgement. I understand the second point perfectly. But for the first point, how do i establish that relationship between DocumentPermission and UserRoles? I'm not sure how to implement that. | |
| Jun 10, 2017 at 14:10 | history | answered | Christophe | CC BY-SA 3.0 |