asked on
EXEC DBMS_FGA.ADD_POLICY(object_schema=>'TAB_IMM',object_name=>'DOC',policy_name=>'POL_DOC',audit_column=>NULL,handler_schema=>NULL,handler_module=>NULL,enable=>TRUE,statement_types=>'INSERT,UPDATE,DELETE',audit_trail=>DBMS_FGA.XML,audit_column_opts=>DBMS_FGA.ANY_COLUMNS);
-<AuditRecord>
<Audit_Type>1</Audit_Type>
<Session_Id>54381498</Session_Id>
<StatementId>1</StatementId>
<EntryId>1</EntryId>
<Extended_Timestamp>2021-05-28T11:36:07.229000Z</Extended_Timestamp>
<DB_User>TAB_IMM</DB_User>
<OS_User>COR\OC</OS_User>
<Userhost>COR\SRV</Userhost>
<OS_Process>10612:5484</OS_Process>
<Terminal>SRV</Terminal>
<Instance_Number>0</Instance_Number>
<Action>100</Action>
<TransactionId>0000000000000000</TransactionId>
<Returncode>0</Returncode>
<Comment_Text>Authenticated by: DATABASE; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.2.3)(PORT=62071))</Comment_Text>
<Priv_Used>5</Priv_Used>
<DBID>1745994699</DBID>
</AuditRecord>
The Timestamp in this xml file is set at 11:36 but in my timezone it should be 13:36.DB_USER EXTENDED_TIMESTAMP ACTION
TAB_IMM 05/28/2021 13:36:07,945000 +02:00 100