Re: Alternatives to Fine Grained Auditing
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 28 May 2015 18:40:09 +0000 (UTC)
Message-ID: <pan.2015.05.28.18.40.09_at_gmail.com>
>> Is anyone aware of any third party tools that provide
>> functionality similar to Oracle's Fine Grained Auditing?
>>
>> We would like to be able to provide reports to our auditors
>> outlining when a table was selected or updated and who
>> was the user who accessed the table.
>>
>> Any recommendations would be most welcome.
>>
>> We are on Standard Edition of Oracle 11 and 12.
>>
>> Thank You
>
> Moria, the requirements you listed can be handled by standard auditing available on both the Oracle Standard and Enterprise editions. The Extended as in db,extended will capture the actual SQL. >
> HTH -- Mark D Powell --
Date: Thu, 28 May 2015 18:40:09 +0000 (UTC)
Message-ID: <pan.2015.05.28.18.40.09_at_gmail.com>
On Thu, 28 May 2015 11:30:07 -0700, Mark D Powell wrote:
> On Thursday, May 28, 2015 at 1:19:57 AM UTC-4, moria..._at_gmail.com wrote:
>> Is anyone aware of any third party tools that provide
>> functionality similar to Oracle's Fine Grained Auditing?
>>
>> We would like to be able to provide reports to our auditors
>> outlining when a table was selected or updated and who
>> was the user who accessed the table.
>>
>> Any recommendations would be most welcome.
>>
>> We are on Standard Edition of Oracle 11 and 12.
>>
>> Thank You
>
> Moria, the requirements you listed can be handled by standard auditing available on both the Oracle Standard and Enterprise editions. The Extended as in db,extended will capture the actual SQL. >
> HTH -- Mark D Powell --
Personally, I have never had business requirements that would force me to use FGA. Standard auditing is usually good enough for most of the nonmilitary personnel.
-- Mladen Gogala The Oracle Whisperer http://mgogala.byethost5.comReceived on Thu May 28 2015 - 20:40:09 CEST