Re: dbms_fga

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Wed, 2 Jan 2008 17:42:32 -0600
Message-ID: <ad3aa4c90801021542s2e3fa9e1q735661c13e87457d@mail.gmail.com>


You can always do an audit all on the table and audit every access.

On Jan 2, 2008 5:21 PM, Wojciech Skrzynecki <wojciech.skrzynecki_at_gmail.com> wrote:

>
>
> Hello
>
>
>
>
>
> I have table with sensitive data. I would like to audit if specifics
> "osusers" execute "select" on this table. I use dbms_fga like below
>
>
>
> begin
> dbms_fga.add_policy
> (object_schema => 'CELIA',
> object_name => 'HERDS',
> policy_name =>'WOJTEK');
> end;
>
>
>
>
>
> Is it possible to audit only specifics "osuser" using dbms_fga package?
> If not can I monitor select statements on the table of some osuser?
>
>
>
>
>
> Regards.
>
> Wojtek
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 02 2008 - 17:42:32 CST

Original text of this message