Community Articles
Find and share helpful community-sourced technical articles
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.
Labels (1)

Problem Statement: Created a user in Ranger. After sometime the user is not reflecting in ranger ui. But he user is reflecting in Ranger DB table x_user and in usersync logs we see the user is getting synchronized all the time.

The user was LDAP user and there was no issue with other users.

ERROR: Below is the issue snap -

"testuser" is not displayed in Ranger UI but its reflected in Ranger DB as shown below-

9541-screen-shot-2016-11-17-at-10156-pm.png

9542-screen-shot-2016-11-17-at-10401-pm.png

ROOT CAUSE: It seems the database for the particular user was corrupted.

RESOLUTION: Inserted below value to the table "x_portal_user_role" after which issue was resolved.

INSERT INTO x_portal_user_role VALUES(NULL,'2016-09-09 00:00:00','2016-09-09 00:00:00',1,1,(SELECT id FROM x_portal_user WHERE login_id='XXXX'),'ROLE_USER',1); 

### NOTE: Replace XXXX with the login_id(username used for login into ranger portal) of the user ('XXXX') You can replace 'ROLE_USER' with 'ROLE_SYS_ADMIN' if you want it to be an admin

98 Views
Don't have an account?
Coming from Hortonworks? Activate your account here
Version history
Revision #:
2 of 2
Last update:
‎08-17-2019 08:03 AM
Updated by:
 
Contributors
Top Kudoed Authors