|Applies To||RSA Product Set: RSA Identity Governance & Lifecycle|
RSA Version/Condition: 7.0.2 and 7.1.0
|Issue||You have created an Segregation of Duties (SOD) rule that detects violations when you add, change and/or remove a user's access. You would like to know what public database schema database view contains this information.|
|Resolution||SOD violations may be found in database view CHANGE_REQUEST, column VIOLATIONS.|
This type of information is in the RSA Identity Governance & Lifecycle Public Database Schema Reference documentation. See page 125 of the RSA Identity Governance and Lifecycle 7.0.2 Public Database Schema Reference and page 121 of the RSA Identity Governance & Lifecycle 7.1 Public Database Schema Reference guide.
You may access this database view as either
Please note that the VIOLATIONS column is of type XMLTYPE. Here are two methods for viewing the data in that column.
You have the following SOD rule and request both entitlements be added to the same user. This generates two violations:
I. From SQL Developer
II. From SQL Plus