| Audit Trail [message #41366] |
Sun, 22 December 2002 16:34  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
