RbacGroup

RBAC groups.

erDiagram
    RbacProvider ||--o{ RbacGroup : "RbacProviderID"
    RbacGroup ||--o{ RbacGroupRole : "RbacGroupID"
    RbacGroup ||--o{ RbacUserGroup : "RbacGroupID"

Fields

Field	Type	Description
Created	datetime	Date/Time the group object was created in the database
CreatedBy	string	OctoSAM user that created the group
Description	string	Description of the group
DirectoryDistinguishedName	string	DN of this group in Active Directory
DirectoryGUID	guid	Object-Guid attribute of this group in Active Directory
DirectoryWhenChanged	datetime	whenChanged attribute from Active Directory
DirectoryWhenCreated	datetime	whenCreated attribute from Active Directory
EntraIdClassification	string	classification property from Entra ID
EntraIdGroupTypes	string	List of group types from Entra ID
EntraIdId	string	Entra ID ID for groups imported from Entra ID
EntraIdOnPremisesLastSyncDateTime	datetime	Date/Time the group was last synchronized
EntraIdOnPremisesNetbiosName	string	NetBIOS name of the on-premises group
EntraIdOnPremisesSamAccountName	string	SAMAccount name of the on-premises group
EntraIdOnPremisesSyncEnabled	boolean	True if this group was synchronized from an on-premises Active Directory to Entra ID
EntraIdSecurityEnabled	boolean	True if this group is an Entra ID security group
EntraIdTenantId	guid	Tenant ID for groups imported from Entra ID
ID	numeric	Internal ID for the RbacGroup entity (Primary Key)
LastFoundInDirectory	datetime	Date/Time the group was last found in Active Directory
LastModification	datetime	Date/Time the group object was last modified in the database
LastModifiedBy	string	OctoSAM user that modified the group
MailAddress	string	Mail address of this group in Active Directory
Name	string	Name of the group
PredefinedGroup	string	Reserved for future use
RbacProviderID	numeric	Internal ID that references the RbacProvider entity (Foreign Key)

References

Column Name	Referenced Table	Description
RbacProviderID	RbacProvider	Contains information about RBAC providers, e.g., Active Directory domains or Entra ID tenants. Currently OctoSAM supports only one RBAC provider per installation. Reserved for future use.

Referenced by

Table	Column Name	Description
RbacGroupRole	RbacGroupID	M:n relation between group and role. A user can be directly in a role (via RbacUserRole) or indirectly via RbacUsergroup and RbacGroupRole.
RbacUserGroup	RbacGroupID	M:n User to Group relation. Replicated from Active Directory. A user can be member of multiple groups, and groups can be nested in AD but OctoSAM flattens the group membership.