SOD_VIOLATION_ROLE

SOD_VIOLATION_ROLE_MAP table

The SOD_VIOLATION_ROLE_MAP¹ table stores information about the roles that are involved in a violation. The roles on the person that are part of a violation are mapped to the roles in the policy rule.
Column Name Description Data type

ID^* Unique ID for this record. Primary key. Numeric

VIOLATION_ID^* Separation of duty violation ID associated with the data. References SOD_VIOLATION_STATUS(ID) and SOD_VIOLATION_HISTORY(ID). Numeric

RULEROLE The DN of the role as referenced in the separation of duty policy rule that is involved in this violation. Character (2000)

PERSONROLE The DN of the role on the person that is found to be in violation of the separation of duty policy rule. Character (2000)

^* Indicates the column is required and not null.
¹ Indicates the table is added in release 5.1.
Parent topic: Separation of duty policy tables

Column Name	Description	Data type
ID^*	Unique ID for this record. Primary key.	Numeric
VIOLATION_ID^*	Separation of duty violation ID associated with the data. References SOD_VIOLATION_STATUS(ID) and SOD_VIOLATION_HISTORY(ID).	Numeric
RULEROLE	The DN of the role as referenced in the separation of duty policy rule that is involved in this violation.	Character (2000)
PERSONROLE	The DN of the role on the person that is found to be in violation of the separation of duty policy rule.	Character (2000)