SOD_POLICY table

The SOD_POLICY1 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.

Column Name Description Data type
ID* Separation of duty policy unique ID. Primary key. Numeric
GLOBAL_ID* The global identifier of this separation of duty policy in LDAP. Numeric
NAME Name of this separation of duty policy. Character (256)
DESCRIPTION Description of this separation of duty policy. Character (500)
BUSINESS_UNIT_NAME Name of the business unit for this separation of duty policy. Character (256)
ENABLED The state of the separation of duty policy. Valid values are:

Enabled (T.

Disabled (F.

Deleted (D.

Character (1)
DN DN to this separation of duty policy as specified in ISIM LDAP store. Character (2000)
VERSION* Timestamp for when this policy was written to the database. It might happen through policy add/modify/delete/evaluate. Numeric

* Indicates the column is required and not null.

1 Indicates the table is added in release 5.1.

Parent topic: Separation of duty policy tables