Description
Problem statement : User and groups having special characters are not populating
in edit policy page.
Example Case : Ranger admin behavior for username usu+gonzáev
While loading Edit policy page; each user details are requested using userSearch API by sending username as search filter.
observed REST request was : http://localhost:6080/service/xusers/users?page=0&pageSize=25&startIndex=0&name=usu%2Bgonz%C3%A1ev
At Ranger admin end when request was received; username was received as : usu+gonzáev
To fetch user details; generated Sql query was : SELECT COUNT(ID) FROM x_user WHERE ((1 = 1) AND LOWER(USER_NAME) LIKE '%usu+gonz??ev%')
Above SQL query didn't returned any row as provided username did not matches with available username in db; in DB username entry was observed as : 'usu+gonz�ev'
REST call returned response code 200 with no records; UI end code did not get any response object so it got stuck there.
Proposed Solution : Rather using user search api; search by username api can be used to avoid encoded character addition.
Attachments
Attachments
Issue Links
- links to