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