统一审计
统一审计代替了传统的标准审计(包括:对象的、权限的和语句的),但是不代替细粒度审计(仍然会出发handler),但是审计轨迹从dba_common_audit_trail转移到了unified_audit_trail:select* from unified_audit_trailorder by event_timestampdesc;FineGrainedAudit 4111440822 0 oracle classroom.example.com pts/1 1 1574592120 (TYPE=(DATABASE)); HR sqlplus@classroom.example.com (TNS V1-V3) 000000000000000000000000000000000000000000000000000000000000000000 2 13 03-NOV-20 08.24.38.629939000 PM SELECT 0 26968 0000000000000000 9237883 HR T062AD11_B select* from t062ad11_b
select* from audit_unified_policies;
select* from audit_unified_enabled_policies;
select* from unified_audit_trailorder by event_timestampdesc;
CREATE AUDIT POLICY audit_mixed_pol4
PRIVILEGES DROP ANY TABLE
ACTIONS
CREATE TABLE, DROP TABLE, TRUNCATE TABLE
ROLES
emp_role
页:
[1]