Community Articles

Find and share helpful community-sourced technical articles.
Welcome to the upgraded Community! Read this blog to see What’s New!
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-



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

Version history
Last update:
‎08-17-2019 08:03 AM
Updated by: