User-context tracking – allows you to determine which user has made a change to a table through the use of procedure SET_CONTEXT_LEVEL in the DBMS_FLASHBACK_ARCHIVE package. The information can be accessed via the GET_SYS_CONTEXT procedure. When set to TYPICAL changes are recorded with userID, global userID, and hostname.
begin
DBMS_FLASHBACK_ARCHIVE.SET_CONTEXT_LEVEL(TYPICAL);
end;
/
Database hardening – You can now associate a subset of tables with a single application and enable flashback just those subset of tables. You can perform the following on the subset of tables:
- Enable flashback on just subset.
- Lock DML operation on subset.
This enables you to protect and track sensitive set of tables. This procedure REGISTER_APPLICATION in package DBMS_FLASHBACK_ARCHIVE is used for this hardening process.
Import and export of history – You can create a temporary history table for a table. This history can be extract showing exact changes to a table over period of time.
Larry Catt
OCP