Madhan Neethiraj created RANGER-4896:
----------------------------------------
Summary: 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
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.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
