Local roles are not picked up by Role Review
Originally Published: 2018-12-15
Last Modified: 2023-09-22
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
Collectors do not pick the new password from the password vault in RSA Governance & Lifecycle Number of Views What files on a workstation with RSA Authentication Agent 7.4.x for Windows may potentially show as false positive from a … Number of Views How to exclude RSA Authentication Manager 8.x from picking up disabled user account data from the Microsoft LDAP directory Number of Views Data Archiving fails in Data Purging step in RSA Identity Governance & Lifecycle Number of Views RSA Identity Router's setup.jsp Network Diagnostics page displays HTTP error 503 or "Service Temporarily Unavailable" or "… Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Reporting on RSA Authentication Manager 8.x users with On-Demand Token, a fixed passcode or a hardware/software token assi… How to Download OTP Token Seed Files from myRSA Anomalix idGenius - SAML Relying Party Configuration - RSA Ready Implementation Guide RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
