Go to the FreeLists Home Page Home Signup Help Login
 



[oracle-l] || [Date Prev] [01-2008 Date Index] [Date Next] || [Thread Prev] [01-2008 Thread Index] [Thread Next]

Re: dbms_fga

  • From: "Andrew Kerber" <andrew.kerber@xxxxxxxxx>
  • To: wojciech.skrzynecki@xxxxxxxxx
  • Date: Wed, 2 Jan 2008 17:42:32 -0600
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@xxxxxxxxx>
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.'
  • References:




[ Home | Signup | Help | Login | Archives | Lists ]

All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
Everything else ©2007 Avenir Technologies, LLC.