| Audit Trail [message #23655] |
Sun, 22 December 2002 16:33  |
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 #23694 is a reply to message #23655] |
Sat, 28 December 2002 06:31  |
Jignesh
Messages: 6
Registered: April 2002
|
Junior Member |
|
|
Yes u can do this without PL/SQL just write triggers for inserting. or even u can make system audit_trial table on by making chane int init.ora audit_trail=true.
Other data regarding time,user information,terminal etc. u can have from user_audit_trail.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
