Oracle FAQ Your Portal to the Oracle Knowledge Grid

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

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

From: Powell, Mark D <>
Date: Mon, 16 Oct 2006 10:32:04 -0400
Message-ID: <>

I believe that VPD on 10g with the proper setting of Oracle contexts via the application could handle your request. When the context is not set or set to the default then VPD filters out the data and when the context is set it allows the data to be selected. The application can set the context so for each user the context is set only when the user is coming through a specific part of the application.  

[] On Behalf Of VIVEK_SHARMA

	Sent: Monday, October 16, 2006 8:25 AM
	Subject: RE: Puzzle - Hiding Data of some rows in a Table


	Seems I have NOT communicated properly in the previous e-mail

	Puzzle 1 - For a Banking Application, for certain V.I.P. Bank
Accounts e.g. of the President of India (translating to respective rows in a set of Tables), a general Staff Official should NOT be able to View the respective Account info. But Bank-wide summation reports e.g.
"Income & Expenditure Report of the Bank as a whole" when fired by the
"same" person should consider the all the Data including those from the
VIP Accounts too.          

        General Staff may Number about 10,000 people spread across geographically dispersed Branches of the Bank.          

        All Staff currently connect thru a common Oracle user & data is owned by a single (common) schema owner name.          

        There is NO column for staff_id (Corresponding to each Bank Staff person) in the Tables currently which probably VPD needs, if I have interpreted VPD correctly.          

        NOTE - Application is OLTP in nature with very High performance needs e.g. Current TPS (Trans/second) stands at a few thousand OLTP transactions.

        Approx a few Million OLTP Transactions (e.g. Debit or Credit transactions to the Bank Accounts thru respective Staff & thru ATMs) are passed per day.          

        Hence Auditing does NOT seem possible.          

        Also Bank Staff Numbers keep changing with new inductions & attritions.          

        Qs 1 Should the same be achieved thru suitable Application Design & Coding Or using some Database Feature is also an Option?          

        Qs 2 Is row-level encrypting available in 10.2 & applicable to this situation?          

        Thanks indeed

Received on Mon Oct 16 2006 - 09:32:04 CDT

Original text of this message