Need Help Regarding FGA_AUDIT [message #674397] |
Fri, 25 January 2019 02:58 |
|
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 |
John Watson
Messages: 8960 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".
|
|
|
|
|