RbacRole
A role is a collection of privileges.
erDiagram
RbacRole ||--o{ RbacGroupRole : "RbacRoleID"
RbacRole ||--o{ RbacRolePrivilege : "RbacRoleID"
RbacRole ||--o{ RbacUserRole : "RbacRoleID"
Fields
| Field |
Type |
Description |
| Created |
datetime |
Date/Time the role object was created |
| CreatedBy |
string |
OctoSAM user that created the object |
| Description |
string |
Description of the Role |
| ID |
numeric |
Internal ID for the RbacRole entity (Primary Key) |
| LastModification |
datetime |
Date/Time the role object was last modified |
| LastModifiedBy |
string |
OctoSAM user that last modified the object |
| Name |
string |
Name of the Role |
| Notes |
string |
Notes |
| PredefinedByOctopus |
boolean |
True for OctoSAM predefined Roles, these roles cannot be deleted |
Referenced by
| Table |
Column Name |
Description |
| RbacGroupRole |
RbacRoleID |
M:n relation between group and role. A user can be directly in a role (via RbacUserRole) or indirectly via RbacUsergroup and RbacGroupRole. |
| RbacRolePrivilege |
RbacRoleID |
M:n relation between Privileges and Roles |
| RbacUserRole |
RbacRoleID |
M:n User to Role relation for users with directly assigned roles |