想找到指定用於在2/15/21 3am et - 8am ET.在database:yyy裡面的修改記錄,我登陸yyy後並沒有發現有任何該使用者在該database的修改
After audit is enabled, find out who made the change on table xxx in the database yyy on date: 2/15/21 3am et - 8am ET.
select * from dba_tab_modifications where Table_name = ‘xxx’
select * from all_tab_modifications where Table_name = ‘xxx’
select * from user_tab_modifications where Table_name = ‘xxx’
Select count(*) from sys.aud$;
count(*)
-------------
79768
select count(*) from dba_audit_trail;
count(*)
-------------
79768
Select count(*) from sys.aud$ where obj$name=’xxx’
count(*)
-------------
0
select count(*) from sys.aud$ where timestamp# between to_date(‘2021-02-15 030000’, ‘yyyy-mm-dd hh24:mi:ss’) and (‘2021-02-15 080000’ ‘yyyy-mm-dd hh24:mi:ss’);
count(*)
-------------
0
select count(*) from dba_audit_trail where timestamp# between to_date(‘2021-02-15 030000’, ‘yyyy-mm-dd hh24:mi:ss’) and (‘2021-02-15 080000’ ‘yyyy-mm-dd hh24:mi:ss’);
count(*)
-------------
100
select count(*) from dba_audit_trail where dba_audit_trail where obj_name=’xxx’;
count(*)
-------------
0
select username, obj_name, to_char(timestamp, ‘YYYY-MM-DD HH24:MI:SS) login from dba_audit_trail where timestamp between to_date(‘2021-02-15 030000’, ‘yyyy-mm-dd hh24:mi:ss’) and (‘2021-02-15 080000’ ‘yyyy-mm-dd hh24:mi:ss’);
USERNAME OBJ_NAME LOGIN
------------ ------------ --------
Gme 2021-02-15 03:00:26
更多資料:
https://www.modb.pro/db/37744
最後結論並沒有以上使用者的操作