September 7, 2011
DB schema for RBAC with multiple levels of roles
Question by blacktie24
I’m trying to come up with a DB schema for an RBAC, and I want to be able to create “departments” and “positions”. Positions will extend the generic privileges of departments. Should I just create a single “roles” table, holding both the positions and departments? Or should I create 3 tables: positions, departments, and roles, with the positions and departments table having a foreign key to the roles table? Thx in advance for your help everyone! Cheers.
Answer by Starx
Standards? This is an unanswerable question, as none such things exists. RBAC is always customized on the basis of the requirements.
You might want to see following resources:
