AUDIT tracking for ROLLBACK and COMMIT [message #385368] |
Mon, 09 February 2009 05:28 |
rizimazhar
Messages: 34 Registered: August 2008 Location: Pakistan
|
Member |
|
|
Hello Everybody
I am a little new in auditing.
I have deployed it successfully. And i can track all changes for HR user based upon the following audit commands settings:
AUDIT ALL BY HR BY ACCESS;
AUDIT SELECT TABLE, UPDATE TABLE, INSERT TABLE, DELETE TABLE BY HR BY ACCESS;
AUDIT EXECUTE PROCEDURE BY HR BY ACCESS;
I am also able to see the sql statements and bind variables as well, as i have used audit_trail="db,extended" option.
I am concerned about one thing, this audit throws all audit data that i need, but i want to see the audit entries for the following commands as well:
ROLLBACK and COMMIT
Can anybody tell me how to achieve that?
Regards
Rizwan
|
|
|