OraFAQ Forum: Security » How to audit dml operations to tables which include old value ,new value without using dml triggers

Home » RDBMS Server » Security » How to audit dml operations to tables which include old value ,new value without using dml triggers

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to audit dml operations to tables which include old value ,new value without using dml triggers [message #61019]

Sun, 21 March 2004 00:16

sohel
Messages: 5
Registered: May 2002

Junior Member

Hello........

Someone please help me. Is there any way�for logging changes made to tables including old value and new value without using the pre post insert,update or delete trigger? I know something about built in audit feature but not clear about that. There is a command - 'Audit insert,update,delete on scott.emp ' which activate audit feature for auditing insert,update or delete operation on emp table in scott schema. But I am not sure how much information about an dml operation I can get with this audit feature activated and where to look for the audited informations from this utility.I mean specificly ,in which dictionary view i should look for the audited informations. Will I get the old and new values for an updation in the dictionary view ?

I will be really grateful for any solution. Many thanks in advance.

Report message to a moderator

Re: How to audit dml operations to tables which include old value ,new value without using dml trigg [message #61020 is a reply to message #61019]

Sun, 21 March 2004 01:15

Anatol Ciolac
Messages: 113
Registered: December 2003

Senior Member

try to see Workspace Manager for Oracle 9. I think that this is what you want.

Report message to a moderator

Re: How to audit dml operations to tables which include old value ,new value without using dml trigg [message #61021 is a reply to message #61019]

Sun, 21 March 2004 03:39

Thiru
Messages: 1089
Registered: May 2002

Senior Member

Hi ,
Auditing doesnt store old&new values of the records. You can turn on auditing and query dba/user_audit_trail etc to get user,operation,date etc. Have a look at the following post for table versioning.

Workspace Manager

-Thiru

[Updated on: Fri, 18 February 2005 23:32]

Report message to a moderator

Re: How to audit dml operations to tables which include old value ,new value without using dml trigg [message #61026 is a reply to message #61021]

Sun, 21 March 2004 17:28

sohel
Messages: 5
Registered: May 2002

Junior Member

Hello........thanks a lot to you.

Report message to a moderator

Previous Topic:	Auditing
Next Topic:	Tables - roles

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 09:32:57 CDT 2025