Home » RDBMS Server » Security » Need Help Regarding FGA_AUDIT (Unix)
Need Help Regarding FGA_AUDIT [message #674397] Fri, 25 January 2019 02:58 Go to next message
Akmmhto
Messages: 25
Registered: September 2018
Junior 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 messageGo to next message
John Watson
Messages: 8082
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".
Re: Need Help Regarding FGA_AUDIT [message #674399 is a reply to message #674397] Fri, 25 January 2019 03:32 Go to previous messageGo to next message
Michel Cadot
Messages: 66722
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
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.
It's easy to test it, isn't it?
Do it and tell us the result, or better show us the whole execution of your test.

Re: Need Help Regarding FGA_AUDIT [message #674402 is a reply to message #674399] Fri, 25 January 2019 07:10 Go to previous message
Akmmhto
Messages: 25
Registered: September 2018
Junior Member
Sorry friends for the terms that I used..

Finally I done this in Dev and found that FGA audit catches data with and without commit..

Previous Topic: standby database error ORA-28374
Next Topic: date when a role or privileges was granted and/or revoke
Goto Forum:
  


Current Time: Wed Dec 11 19:03:37 CST 2019