DB Wiki

The user context can now be tracked with FDA and therefore see which user made changes to a table.
Use DBMS_FLASHBACK_ARCHIVE.SET_CONTEXT_LEVEL procedure to do this …

ALL     : All contexts from the SYS_CONTEXT function are stored.
TYPICAL : Only basic auditing attributes from the USERENV context are stored.
NONE    : No context information is stored.

EXEC DBMS_FLASHBACK_ARCHIVE.SET_CONTEXT_LEVEL('TYPICAL');

Use DBMS_FLASHBACK_ARCHIVE.GET_SYS_CONTEXT function to retrieve the data …

SELECT DBMS_FLASHBACK_ARCHIVE.GET_SYS_CONTEXT(versions_xid, 'USERENV','SESSION_USER')
FROM   FDA_TABLE
       VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 1 AND SYSTIMESTAMP;