Skip to content

RbacUserRole

M:n User to Role relation for users with directly assigned roles.

erDiagram
    RbacRole ||--o{ RbacUserRole : "RbacRoleID"
    RbacUser ||--o{ RbacUserRole : "CreatedByRbacUserID"
    RbacUser ||--o{ RbacUserRole : "RbacUserID"

Fields

Field Type Description
Created datetime Date/Time this relation was created
CreatedByRbacUserID numeric Internal ID that references the RbacUser entity (Foreign Key)
ID numeric Internal ID for the RbacUserRole entity (Primary Key)
RbacRoleID numeric Internal ID that references the RbacRole entity (Foreign Key)
RbacUserID numeric Internal ID that references the RbacUser entity (Foreign Key)

References

Column Name Referenced Table Description
CreatedByRbacUserID RbacUser User object for RBAC. Typically replicated from Active Directory.
RbacRoleID RbacRole A role is a collection of privileges
RbacUserID RbacUser User object for RBAC. Typically replicated from Active Directory.