[
https://issues.apache.org/jira/browse/RANGER-4896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Madhan Neethiraj updated RANGER-4896:
-------------------------------------
Attachment: RANGER-4895.patch
> foreign key references to user table should be removed from login records
> table
> -------------------------------------------------------------------------------
>
> Key: RANGER-4896
> URL: https://issues.apache.org/jira/browse/RANGER-4896
> Project: Ranger
> Issue Type: Improvement
> Components: Ranger
> Reporter: Madhan Neethiraj
> Priority: Major
>
> Ranger records all logins to admin server in {{x_auth_sess}} table. This
> table has foreign key reference to user record stored in {{x_portal_user}}
> table.
> When a user is deleted in Ranger, all related records in {{x_auth_sess}}
> table are deleted - which can take a long time if the user has large number
> of login records in {{x_auth_sess}} table.
> Removing foreign key references from {{x_auth_sess}} to {{x_portal_user}}
> table will eliminate the need to remove {{x_auth_sess}} records when a user
> is deleted - which can significantly reduce the time taken to delete users.
> In addition, this can improve performance of user login as well. Also, it
> might be desirable to retain login records even after deletion of users.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
