[
https://issues.apache.org/jira/browse/RANGER-4353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17754869#comment-17754869
]
Ramachandran commented on RANGER-4353:
--------------------------------------
Admin Audit log is written into {{x_trx_log}} table whenever we do CUD
operations on policy/role/user/group in Ranger
We used to store the below info
Example:
{{Operation :Policy deleted <id>}}
{{Actions:delete/create/update}}
{{Session Id:<sessionId>}}
{{User: <admin>}}
{{Date:<date>}}
and some other info in {{x_trx_log}} table and this will be populated in the UI
We are seeing {{x_trx_log}} table is growing very fast. This also might affect
DB performance. We do not have any flag to disable admin audit.
This ticket will be a great initiative to address this performance issue
> Purging of x_auth_sess records should purge corresponding records in
> x_trx_log as well
> --------------------------------------------------------------------------------------
>
> Key: RANGER-4353
> URL: https://issues.apache.org/jira/browse/RANGER-4353
> Project: Ranger
> Issue Type: Task
> Components: Ranger
> Reporter: Madhan Neethiraj
> Assignee: Pradeep Agrawal
> Priority: Major
>
> RANGER-4255 introduced REST API to purge x_auth_sess table records that were
> created earlier than 180 days (by default). This purging should be extended
> to x_trx_log table records as well, as it can take up significant space.
> x_trx_log table track details of changes to individual attributes of
> policies/services/security-zones/users/groups/roles.
> CC: [~pradeep], [~abhay], [~vel], [~ankita], [~suchnit]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
