Re: Puzzle - Hiding Data of some rows in a Table

There is of course a performance trade off with FGAC.

anand

On 16/10/06, rjamya <rjamya_at_gmail.com> wrote:
>
> VPD ... or fine grained auditing ... that's what you are looking for,.
>
> But OTOH, i think your requirements are mixed up ...
> 1. You don't want everyone to see the data that VIP should see.
> 2. Anyone can fireup a report that will show the data that is protected in
> (1).
>
> if that is the case, why bother?
>
> if you don't want DBAs to see this data, your only choice then is Database
> Vault. Lookup on OTN for more info.
> Raj
>
> On 10/16/06, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> wrote:
> >
> > Folks
> > Puzzle 1 - For a Banking Application, for certain V.I.P. Accounts
> > (translating to respective rows in a set of Tables), the general Staff
> > should NOT be able to View the respective Account info. But Bank-wide
> > summation reports fired by the same staff should consider the Data from the
> > VIP Accounts too.
> >
> > Puzzle 2 Additionally DBAs also should also NOT be able to see the above
> > data.
> >
> --
> ----------------------------------------------
> Got RAC?
>

-- 
All I need to make a comedy is a park, a policeman and a pretty girl -
Charlie Chaplin

--
http://www.freelists.org/webpage/oracle-l