[ 
https://issues.apache.org/jira/browse/RANGER-4353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17756916#comment-17756916
 ] 

Pradeep Agrawal commented on RANGER-4353:
-----------------------------------------

x_trx_log table entries can not be removed implicitly, However sess_id field of 
that table can be set to Null.

A separate option can be introduce to remove records from x_trx_log table.

 

> 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)

Reply via email to