Re: Disallow access to column of a table

You have to use a view to restrict columns.

If permissions or synonyms won't do the job correctly, you can use VPD to restrict a particular community of users from accessing the table, and permit them to use the view instead, and vice-versa.

Hope this helps!

-Tim

-----Original Message-----

From: Jeffrey Beckstrom [mailto:JBECKSTROM_at_gcrta.org] Sent: Monday, October 5, 2009 01: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:53:14 CDT