You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ranger.apache.org by "Madhan Neethiraj (Jira)" <ji...@apache.org> on 2024/08/11 01:22:00 UTC
[jira] [Updated] (RANGER-4896) foreign key references to user table should be removed from login records table
[ https://issues.apache.org/jira/browse/RANGER-4896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Madhan Neethiraj updated RANGER-4896:
-------------------------------------
Description:
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.
was:
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.
> 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)