首頁>技術>

想找到指定用於在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

最後結論並沒有以上使用者的操作

10
最新評論
  • BSA-TRITC(10mg/ml) TRITC-BSA 牛血清白蛋白改性標記羅丹明
  • 網際網路架構演進之路