[RANGER-2278] Unable to delete user if he has references in new ref tables.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.1, 1.1.1, 1.2.0, 1.2.1
• Fix Version/s: 1.0.1, 2.0.0, 1.1.1, 1.2.1
• Component/s: Ranger
• Assignee: Pradeep Agrawal
• Reporter: Pradeep Agrawal
• Created: 05/Nov/18 13:44
• Updated: 23/Jul/19 05:49
• Resolved: 06/Nov/18 05:38

Description

Created a service/policy from a user. While trying to delete the same user was unable to delete the user as "added_by_id" and "upd_by_id" field having references of user id and due to foreign key constraint ranger doesn't allow user deletion. 

This is related to RANGER-2203 as policy structure has been changed and new tables are also having "added_by_id" and "upd_by_id".

Issue Links

• is cloned by: RANGER-2513 Unable to delete user if he has references in new ref tables.
• links to: Apache RR