Home » RDBMS Server » Security » audit dml statement
audit dml statement [message #109010] Mon, 21 February 2005 02:39 Go to next message
ketan patel
Messages: 3
Registered: October 2001
Junior Member
Hi friends,

I want to audit all dml operation performed on perticulate schema so if possible then please help me
Re: audit dml statement [message #109015 is a reply to message #109010] Mon, 21 February 2005 07:14 Go to previous message
motasemsh
Messages: 3
Registered: October 2002
Location: Syria
Junior Member
Hi:

I think you need to write triggers for tables you want to audit and store something in one master table consists of (table name, operation, date ...) I hope it is a way.

Bye
Previous Topic: sql username and password
Next Topic: Security Issue
Goto Forum:
  


Current Time: Fri Apr 19 18:27:33 CDT 2024