RE: Disallow access to column of a table

Create table data(a number, common_data varchar2(10), secret_data varchar2(10));

Create view no_secret_Data as select a,common_Data from data;

Grant select on view to less privileged users.
-Mark

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeffrey Beckstrom Sent: Monday, October 05, 2009 3:35 PM
To: oracle-l-freelists; oracle-db-l
Subject: Disallow access to column of a table

We have a requirement to disallow access to a few columns of a table. Any suggestions on how to do this? I was thinking of Virtual Private Database but that would exclude the entire row.

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

--

http://www.freelists.org/webpage/oracle-l Received on Mon Oct 05 2009 - 14:46:35 CDT