[
https://issues.apache.org/jira/browse/RANGER-4907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Subhrat Chaudhary updated RANGER-4907:
--------------------------------------
Summary: Optimize user and grpup delete operation (was: Optimize user
delete operation)
> Optimize user and grpup delete operation
> ----------------------------------------
>
> Key: RANGER-4907
> URL: https://issues.apache.org/jira/browse/RANGER-4907
> Project: Ranger
> Issue Type: Improvement
> Components: admin
> Reporter: Subhrat Chaudhary
> Assignee: Subhrat Chaudhary
> Priority: Major
>
> If a user has large number of associations with groups, policies, the user
> delete operation can take large amount of time, especially while updating the
> policies. Since to update a policy, we have large number of validations in
> place. This can be even worse, if multiple user delete requests are received
> at the same time. We can add following optimizations to improve the user
> delete performance:
> * Remove foreign key relation of x_user with x_auth_sess, with this we can
> skip updating the user references in x_auth_sess when a user is deleted.
> * Currently all policy reference for a user are cleaned up and updated ones
> are added again. We can remove policy reference only for the user being
> deleted.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
