Re: Puzzle - Hiding Data of some rows in a Table
- From: "Yavor Ivanov" <Yavor_Ivanov@xxxxxxxx>
- To: VIVEK_SHARMA@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 16 Oct 2006 13:56:42 +0300
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@xxxxxxxxxxx>
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
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
