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
Recursive Faulty view upon clicking on 'Additional Information' under CR link in the Activity/Approval tabs in RSA Governa… Number of Views Salesforce AFX Connector 'Update an Account' Capability fails to update additional Parameters in RSA Identity Governance &… Number of Views A custom query to show assigned or unassigned software tokens Number of Views Authentication error with LDAP user assigned the Super Admin role while providing additional credentials to the RSA Authen… Number of Views View the Next Steps for Promotion for Maintenance Number of Views
Trending Articles
Troubleshooting RSA SecurID Access Identity Router to RSA Authentication Manager test connection failures RSA SecurID Software Token 5.0.2 Downloads for Microsoft Windows RSA Authentication Manager 8.9 Release Notes (January 2026) Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA Authentication Manager 8.8 Setup and Configuration Guide
Don't see what you're looking for?
