Home » RDBMS Server » Server Administration » a question about FGA commit
icon5.gif  a question about FGA commit [message #116108] Sun, 17 April 2005 17:15 Go to next message
dbconstructer
Messages: 11
Registered: April 2005
Junior Member
Since FGA policy does not wait for a commit statement for the DML and audit records are created immediately when the manipulation happened,how can I tell if the DML was commit or rollback according to the dba_fga_audit_trail?

Report message to a moderator

Re: a question about FGA commit [message #116192 is a reply to message #116108] Mon, 18 April 2005 09:17 Go to previous message
pscjhe
Messages: 38
Registered: April 2005
Member
Being anonymous transaction, FGA won't tell you the original DML successful or not. It has to be done using regular audit's WHENEVER SUCCESSFUL/UNSUCCESSFUL option.

Report message to a moderator

Previous Topic: Help: use index
Next Topic: ORA-04020 deadlock detected
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 02:32:34 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.