Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Puzzle - Hiding Data of some rows in a Table

Puzzle - Hiding Data of some rows in a Table

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Mon, 16 Oct 2006 16:03:07 +0530
Message-ID: <BBD944BCAC3AB4499DFBAFB1D8AF302001EC0794@BLRKECMSG11.ad.infosys.com>

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

Received on Mon Oct 16 2006 - 05:33:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US