【oracle】dbms_flashback

1028-04 dbms_flashback
--查看执行过的sql:select,insert,update,delete
select * from v$sql
where service ='ionmc' and parsing_schema_name = 'SCOTT';

--查看 执行过的sql: insert,update,delete
grant select any transaction to scott;
select * from flashback_transaction_query where logon_user = 'SCOTT';

原文地址:https://www.cnblogs.com/greenZ/p/8721807.html