Details
-
Improvement
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
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.
Attachments
Issue Links
- is related to
-
-
- Resolved
-