Home » RDBMS Server » Security » How to audit a table
How to audit a table [message #538] Mon, 18 February 2002 23:49 Go to next message
Marta
Messages: 2
Registered: February 2002
Junior Member
I want to create an audit:
a- I need to create a table to keep all the needed information
b- I need to audit a certain table 'emp' for DML actions (inserts, updates,deletes)
c- I needto know
Who's done the action?
When the action was done?
What was the previous value?
Any hints, please?
Re: How to audit a table [message #539 is a reply to message #538] Tue, 19 February 2002 01:09 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
1. enable auditing with intialization parameter AUDIT_TRAIL.
2. use audit command to choose specific auditing
Re: How to audit a table [message #1782 is a reply to message #538] Wed, 29 May 2002 11:35 Go to previous messageGo to next message
Ale
Messages: 3
Registered: May 2002
Junior Member
I want to audit a table and get information about what data was modified and what was the previous value.
Re: How to audit a table [message #1785 is a reply to message #538] Wed, 29 May 2002 13:35 Go to previous message
Ale
Messages: 3
Registered: May 2002
Junior Member
I want to audit a table and get information about what data was modified and what was the previous value.
Previous Topic: Important Security level
Next Topic: Password after initial install 9i
Goto Forum:
  


Current Time: Fri Dec 09 03:28:50 CST 2022