SOD_RULE table

SOD_RULE table

The SOD_RULE¹ table stores information about a separation of duty policy rule. This table is used by the inner workings of separation of duty implementation and separation of duty reports.
Column Name Description Data type

ID^* Separation of duty policy rule unique ID. Primary key. Numeric

POLICY_ID^* Separation of duty policy ID associated with the data. References SOD_POLICY(ID). Numeric

GLOBAL_ID^* The global ID of this separation of duty policy rule in LDAP. Numeric

NAME Name of this separation of duty policy rule. Character (500)

DESCRIPTION Description of this separation of duty policy rule. Character (500)

CARDINALITY Allowed number of roles defined for this policy rule. Numeric

VERSION^* Timestamp for when this policy rule was written to the database. It might happen through policy add, modify, delete, and evaluate. Numeric

^* 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^*	Separation of duty policy rule unique ID. Primary key.	Numeric
POLICY_ID^*	Separation of duty policy ID associated with the data. References SOD_POLICY(ID).	Numeric
GLOBAL_ID^*	The global ID of this separation of duty policy rule in LDAP.	Numeric
NAME	Name of this separation of duty policy rule.	Character (500)
DESCRIPTION	Description of this separation of duty policy rule.	Character (500)
CARDINALITY	Allowed number of roles defined for this policy rule.	Numeric
VERSION^*	Timestamp for when this policy rule was written to the database. It might happen through policy add, modify, delete, and evaluate.	Numeric