Created 03-09-2017 07:42 AM
Hi ,
I am using mysql databse from Ranger .
As Standard user name / database name : ranger / ranger & rangerlogger / ranger_audit
In which databases ( and table) does usersync process will store LDAP / AD username information?
Thanks
JJ
Created 03-09-2017 08:06 AM
Are you looking out for the 'ranger' database table 'x_portal_user'
As per : https://cwiki.apache.org/confluence/display/RANGER/Ranger+0.5.0+Database+Schema
This table contains user profile and credentials of Ranger Admin users. It also contains users synced from external sources but credentials are not stored and password field contains garbage value. Important attributes of this table are login_id, password, email, status and user_src. 'user_src' field value ‘0’ represents internal user while ‘1’ represents external user. External users are users synced from external sources i.e (UNIX / LDAP / AD).
.
Created 03-09-2017 08:06 AM
Are you looking out for the 'ranger' database table 'x_portal_user'
As per : https://cwiki.apache.org/confluence/display/RANGER/Ranger+0.5.0+Database+Schema
This table contains user profile and credentials of Ranger Admin users. It also contains users synced from external sources but credentials are not stored and password field contains garbage value. Important attributes of this table are login_id, password, email, status and user_src. 'user_src' field value ‘0’ represents internal user while ‘1’ represents external user. External users are users synced from external sources i.e (UNIX / LDAP / AD).
.