Puzzle - Hiding Data of some rows in a Table
- From: "VIVEK_SHARMA" <VIVEK_SHARMA@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 16 Oct 2006 16:03:07 +0530
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
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
for the use of the addressee(s). If you are not the intended recipient, please
notify the sender by e-mail and delete the original message. Further, you are
not to copy, disclose, or distribute this e-mail or its contents to any other
person and any such actions are unlawful. This e-mail may contain viruses.
Infosys has taken every reasonable precaution to minimize this risk, but is not
liable for any damage you may sustain as a result of any virus in this e-mail.
You should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content of all
messages sent to or from this e-mail address. Messages sent to or from this
e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
Other related posts:
