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

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?

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