Home » RDBMS Server » Security » Audit Trail
Audit Trail [message #4568] Sun, 22 December 2002 16:32 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 #4571 is a reply to message #4568] Mon, 23 December 2002 00:11 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Use the Oracle built-in Audit functionality.
details are available at OTN(Oracle8i) or here (Oracle9i).

HTH,
MHE
Previous Topic: Oracle system created DBA role dropped by accident
Next Topic: Audit Trail
Goto Forum:
  


Current Time: Fri Mar 29 05:58:46 CDT 2024