OraFAQ Forum: Security » How to audit a table

Home » RDBMS Server » Security » How to audit a table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to audit a table [message #538]

Mon, 18 February 2002 23:49

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?

Report message to a moderator

Re: How to audit a table [message #539 is a reply to message #538]

Tue, 19 February 2002 01:09

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

Report message to a moderator

Re: How to audit a table [message #1782 is a reply to message #538]

Wed, 29 May 2002 11:35

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.

Report message to a moderator

Re: How to audit a table [message #1785 is a reply to message #538]

Wed, 29 May 2002 13:35

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.

Report message to a moderator

Previous Topic:	Important Security level
Next Topic:	Password after initial install 9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 07 14:16:01 CDT 2026