It’s been a while since I last posted on the NIST RBAC Data Model and there have some (small) changes that make it a good idea to do a new post on this topic.
I’ve made two changes to the data model:
- Removed the many-to-many mapping in user/sessions and replaced it with a one-to-many mapping because each session is associated with a single user and each user is associated with one or more sessions.
- Renamed table “user” to “users” to avoid clashes in PostgreSQL and changed all associated references
Specific output formats for both MySQL 5 and PostgreSQL 9 are included below.