Review definition can initiate a SQL select onto the IG application database to obtain a Review Set

For a User or Account Review - the Review Set may be obtained live at Review initiation by a SQL Query

e.g. Application Permission Review, the permissions to be reviewed can be set by a selection rule.

List of Permissions Query statement:

SELECT permissions
FROM permission_catalog
WHERE application = 'MyAccess' and permission like 'SVN-CORP%'

In this example, the reviewer will review all the permissions that begin with SVN-CORP regardless of the number of permissions that exist at that time.

Comments

  • Thanks for the suggestion. This item has been added to the Identity Governance backlog.