RbacUserOrganization
This n:m relation table models the RBAC User to Organization Privilege in a way that's easy to integrate into SQL Queries. The information is redundant to the Organization privileges assigned to the user.
erDiagram
Organization ||--o{ RbacUserOrganization : "OrganizationID"
RbacUser ||--o{ RbacUserOrganization : "RbacUserID"
Fields
| Field |
Type |
Description |
| ID |
numeric |
Internal ID for the RbacUserOrganization entity (Primary Key) |
| OrganizationID |
numeric |
Internal ID that references the Organization entity (Foreign Key) |
| RbacUserID |
numeric |
Internal ID that references the RbacUser entity (Foreign Key) |
| UpdateEnabled |
boolean |
If true, the RBAC user has update privileges in this organization. Update privileges for objects and fields are also required. |
References
| Column Name |
Referenced Table |
Description |
| OrganizationID |
Organization |
Defines the organizations of this OctoSAM installation |
| RbacUserID |
RbacUser |
User object for RBAC. Typically replicated from Active Directory. |