Need Help Regarding FGA_AUDIT [message #674397] |
Fri, 25 January 2019 02:58 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/d5dbce2ba13f1eecd998e0fffe1c1b29?s=64&d=mm&r=g) |
Akmmhto
Messages: 38 Registered: September 2018
|
Member |
|
|
Hi team,
We have enable FGA on table for insert update and delete.
We checked and found that one day 2 records has been inserted in table.
But data is not available in the reference table.
And also there is no delete query catched in FGA AUDIT.
Can you suggest what is issue here...
And another question is , Suppose I am inserted a row in table and doesn't commit.
So will the FGA audit records this insert or not.
Does it saves records only committed data.
Regards,
Anup
[Updated on: Fri, 25 January 2019 02:59] Report message to a moderator
|
|
|
Re: Need Help Regarding FGA_AUDIT [message #674398 is a reply to message #674397] |
Fri, 25 January 2019 03:15 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8930 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Without seeing the procedure calls you made to set up FGA and the DML statements you are running, it is not possible to assist.
btw, I wish you would not say "record" when you mean "row".
|
|
|
|
|