CA UIM CABI login access denied for superuser after creating a test Organization

Document ID : KB000072228
Last Modified Date : 27/02/2018
Show Technical Document Details
Issue:
Customer can login successfully into CABI portlet with 'Superuser' account but is then greeted with the following message: "Access Denied You do not have permission to view this page. Please contact your system administrator or log in as a user with permission"
Environment:
UIM Version : 8.47 
UMP Version : 8.47 
cabi probe version : 1.0 
CABI is installed on a standalone machine.
Cause:
From superuser role, ROLE_USER, ROLE_ADMINISTRATOR was missing. ROLE_ADMINISTRATOR was missing from CABI_REST_USER.
Resolution:
There are three tables that contain information about CABI users and their user roles:

JIUser is user table.
- JIRole is role table.
- JIUserRole is joint table
 
- Checked in JIUserRole table, just role ROLE_SUPERUSER was assigned to 'superuser' user.
- Insert a row in JIUserRole table, assigned below roles to 'superuser' user:
       --> ROLE_USER
       --> ROLE_ADMINISTRATOR
- Also, add ROLE_ADMINISTRATOR role to CABI_REST_USER.
- Deactivate/activate cabi probe.
 
Additional Information:
https://community.jaspersoft.com/wiki/setting-row-level-security