Local roles are not picked up by Role Review
Originally Published: 2018-12-15
Article Number
Applies To
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 7.1.0
Issue
Cause
Resolution
Workaround
1. Open your SQL Developer and then open a blank worksheet
2. Go to the Views, locate and open V_ROLES_TO_APPS ...
3. Click the SQL tab of V_ROLES_TO_APPS, then copy the entire text to the blank worksheet, remove the semicolon (;) at the end of the text and then add the below:
UNION ALL
select distinct role_id, application_id from t_av_roledefinitions where deletion_date IS NULL;
4. Finally, click 'Execute' icon on the worksheet to compile the change and you should see the below message:
View "AVUSER"."V_ROLES_TO_APPS" created.
5. Test Role review and verify that the local roles are included in the role review items.
Related Articles
After refreshing a user access review, the business source values for roles (role sets) display as null in RSA Identity Go… Number of Views Collectors do not pick the new password from the password vault in RSA Governance & Lifecycle Number of Views How to Disable 'Add Members' button under Role management option for Roles using RSA Via Lifecycle & Governance Number of Views Requests in state "Waiting On Dependencies" remain stuck in the fulfillment phase in RSA Identity Governance & Lifecycle Number of Views A Business Role Request with an existing unsuccessful Pending Submission Request that creates a Pending Account can still … Number of Views
Don't see what you're looking for?
