Home » RDBMS Server » Security » Audit Trail
Audit Trail [message #23655] Sun, 22 December 2002 16:33 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 #23663 is a reply to message #23655] Mon, 23 December 2002 06:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10697
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
enable auditing in the datatbase.
NOT DIFFICULT
Re: Audit Trail [message #23694 is a reply to message #23655] Sat, 28 December 2002 06:31 Go to previous message
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.
Previous Topic: Audit Trigger Failure
Next Topic: Audit Trigger Failure
Goto Forum:
  


Current Time: Thu May 19 00:57:24 CDT 2022