Separation of duty policy tables

The tables described in this section are used for storing information about separation of duty policies and violations.

SOD_OWNER table
The SOD_OWNER¹ table stores information about the owners for a separation of duty policy. There can be more than one owner for each separation of duty policy.
SOD_POLICY table
The SOD_POLICY¹ table stores information about a separation of duty policy. This table is used by the inner workings of separation of duty implementation and separation of duty reports.
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.
SOD_RULE_ROLE table
The SOD_RULE_ROLE¹ table stores information about the roles listed in a separation of duty policy rule. This table is used by the inner workings of separation of duty implementation and separation of duty reports.
SOD_VIOLATION_HISTORY table
The SOD_VIOLATION_HISTORY¹ table stores historical information about exemptions and violations for a separation of duty policy.
SOD_VIOLATION_STATUS table
The SOD_VIOLATION_STATUS¹ table stores current information about exemptions and violations for a separation of duty policy.
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.

Parent topic: Database tables reference