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
Unable to save Application Role mapping in Role Collector in RSA Identity Governance & Lifecycle Number of Views Role collector design changes for RSA Identity Governance & Lifecycle 7.x Number of Views RSA Identity Governance & Lifecycle Role Collector (RDC) fails with ORA-30926 error Number of Views Existing Role memberships later granted through Parent Roles are not revoked when the Role memberships are removed from th… Number of Views Importing roles from one environment to another is not importing the role entitlements custom attribute values in RSA Iden… Number of Views
Trending Articles
Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide How to Download OTP Token Seed Files from myRSA RSA Authentication Manager 8.9 Release Notes (January 2026)
Don't see what you're looking for?
