Oracle 12c how to purge the FGA audit records before a certain date
在下面的步骤前,先了解下这些选项的含义,由于我设置额db_extended所以在过程中我需要选择清除的对象为AUDIT_TRAIL_AUD_STD.
Constant | Type | Value | Description |
---|---|---|---|
AUDIT_TRAIL_ALL |
PLS_INTEGER |
15 | All audit trail types. This includes the standard database audit trail (SYS.AUD$ and SYS.FGA_LOG$ tables), operating system (OS) audit trail, and XML audit trail. |
AUDIT_TRAIL_AUD_STD |
PLS_INTEGER |
1 |
Standard database audit records in the SYS.AUD$ table |
AUDIT_TRAIL_DB_STD |
PLS_INTEGER |
3 |
Both standard audit (SYS.AUD$ ) and FGA audit(SYS.FGA_LOG$ ) records |
AUDIT_TRAIL_FGA_STD |
PLS_INTEGER |
2 |
Standard database fine-grained auditing (FGA) records in the SYS.FGA_LOG$ table |
AUDIT_TRAIL_FILES |
PLS_INTEGER |
12 | Both operating system (OS) and XML audit trails |
AUDIT_TRAIL_OS |
PLS_INTEGER |
4 | Operating system audit trail. This refers to the audit records stored in operating system files. |
AUDIT_TRAIL_XML |
PLS_INTEGER |
8 | XML audit trail. This refers to the audit records stored in XML files. |
begin
DBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP
(
audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_FGA_STD,
last_archive_time => sysdate - 7
);
end;
/
begin
DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL
(
audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_FGA_STD,
use_last_arch_timestamp => true
);
end;
/
分类:
ORACLE
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 没有源码,如何修改代码逻辑?
· 一个奇形怪状的面试题:Bean中的CHM要不要加volatile?
· [.NET]调用本地 Deepseek 模型
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· .NET Core 托管堆内存泄露/CPU异常的常见思路
· 微软正式发布.NET 10 Preview 1:开启下一代开发框架新篇章
· 没有源码,如何修改代码逻辑?
· PowerShell开发游戏 · 打蜜蜂
· 在鹅厂做java开发是什么体验
· WPF到Web的无缝过渡:英雄联盟客户端的OpenSilver迁移实战