Re: Disallow access to column of a table

  • From: "Tim Gorman" <tim@xxxxxxxxx>
  • To: JBECKSTROM@xxxxxxxxx, "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>, "oracle-db-l" <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>
  • Date: Mon, 05 Oct 2009 19:53:14 +0000


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!


-----Original Message-----
From: Jeffrey Beckstrom [mailto:JBECKSTROM@xxxxxxxxx]
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

Other related posts: