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)

SYMPTOM: Created a user in Ranger. User is visible in ranger DB but not visible in Ranger UI

ERROR: Logged into mysql DB and executed below command -

SELECT * FROM ranger.x_user where user_name in ('userA');

==> This shows the user exist in x_user table.

SELECT * FROM ranger.x_portal_user where user_name in ('userA');

==> The user is also present in x_portal_user

ROOT CAUSE: Suspected corruption on Ranger DB sometimes.

RESOLUTION: Executing below command resolved the issue

>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); 

Replace XXXX with the login_id of the user ('userA') You can replace 'ROLE_USER' with 'ROLE_SYS_ADMIN' if you want it to be an admin

106 Views
Don't have an account?
Coming from Hortonworks? Activate your account here
Version history
Revision #:
1 of 1
Last update:
‎12-22-2016 05:15 AM
Updated by:
 
Contributors
Top Kudoed Authors