Home » RDBMS Server » Security » Audit Trail
Audit Trail [message #41366] Sun, 22 December 2002 16:34 Go to next message
CreativePresence
Messages: 73
Registered: December 2002
Member
Im creating a command file that prompts users to enter values that will be inserted into a table, of which contains Primary/Foriegn Keys. That part i can do, but i need to be able to be able to maintain an effective audit trail of all such transactions. Is this possible solely within SQL or would i need to delve into the relms of PL/SQL? What im asking, is it difficult & how can it be achieved?
Thanks
(UK)
Re: Audit Trail [message #41373 is a reply to message #41366] Mon, 23 December 2002 13:33 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
The usual method is to create a trigger on the table that fires in response to an insert and/or update. The trigger logic would log audit info as needed.
Previous Topic: Audit Trail
Next Topic: Audit Trigger Failure
Goto Forum:
  


Current Time: Wed May 25 04:38:41 CDT 2022