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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0
• Fix Version/s: 2.0.0
• Component/s: Ranger
• Assignee: Pradeep Agrawal
• Reporter: Pradeep Agrawal
• Created: 23/Jul/19 05:49
• Updated: 24/Jul/19 06:05
• Resolved: 24/Jul/19 06:05

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-2232 and RANGER-2414 as security zone and role feature has been added and new tables are also having "added_by_id" and "upd_by_id".

Issue Links

• is a clone of: RANGER-2278 Unable to delete user if he has references in new ref tables.
• links to: Apache RR