| Auditing DML [message #439004] |
Wed, 13 January 2010 10:21  |
smunir362
Messages: 310
Registered: September 2007
|
Senior Member |
|
|
|
I have table1,table2 and table3 in a abc schema. I want to enable audit for DML(insert,update,delete) statements against these tables for all the db users. How can I do that.
|
|
|
|
|
|
|
|
| Re: Auditing DML [message #439008 is a reply to message #439006] |
Wed, 13 January 2010 10:41  |
smunir362
Messages: 310
Registered: September 2007
|
Senior Member |
|
|
I already follow these steps.
1. set audit_trail=DB and restart instance;
2. SQL>AUDIT INSERT, UPDATE ON oe.customers;
3. Insert record in oe.customers table.
4. Then check audited record by query
Select * from db_audit_trail;
but in action name column I saw SESSION REC. But it should be insert.
|
|
|
|
|
|
| Re: Auditing DML [message #439017 is a reply to message #439008] |
Wed, 13 January 2010 11:01 |
 |
Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
SQL> Select * from db_audit_trail;
Select * from db_audit_trail
*
ERROR at line 1:
ORA-00942: table or view does not exist
Do NOT explain what you did, show us by copying and pasting your SQL*Plus session.
Regards
Michel
[Updated on: Wed, 13 January 2010 11:02] Report message to a moderator |
|
|
|
|
|
| Re: Auditing DML [message #440652 is a reply to message #439018] |
Tue, 26 January 2010 08:59 |
smunir362
Messages: 310
Registered: September 2007
|
Senior Member |
|
|
I successfully configure audit for objects.
But now I want to store old vale also in case of update data.
How to do it.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Auditing DML [message #441761 is a reply to message #440675] |
Wed, 03 February 2010 00:40 |
smunir362
Messages: 310
Registered: September 2007
|
Senior Member |
|
|
I check the help but could not find my solution in FGA. All the avaliable solutions are trigger on the table.
My question is how can I use FGA for storing old and new vales.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
