Skip to content

RbacGroupRole

M:n relation between group and role. A user can be directly in a role (via RbacUserRole) or indirectly via RbacUsergroup and RbacGroupRole.

erDiagram
    RbacGroup ||--o{ RbacGroupRole : "RbacGroupID"
    RbacRole ||--o{ RbacGroupRole : "RbacRoleID"
    RbacUser ||--o{ RbacGroupRole : "CreatedByRbacUserID"

Fields

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

References

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