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

	For Puzzle1 - this is easily doable using VPD. You can do almost everytnig using VPD.
	For Puzzle2 - I doubt this is doable ( to hide information from you dba? get serious! ;-) ), but Oracle promises this is possible using the new tecnology Oracle Database Vault:
	http://www.oracle.com/database/database-vault.html

Rgds,
Yavor         

On Mon, 16 Oct 2006 13:33:07 +0300, 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.
>
>
>
>
> Any ideas how this can be achieved?
>
>
>
>
> Qs Does Row based Encryption perchance exist in 10.2? If so, is it a
> possible solution? If so, does it have performance overheads?
>
>
>
>
> Thanks indeed
>

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