Re: Disallow access to column of a table

From: Tim Gorman <>
Date: Mon, 05 Oct 2009 19:53:14 +0000
Message-ID: <W7228714846251091254772394_at_webmail13>


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 [] 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

-- Received on Mon Oct 05 2009 - 14:53:14 CDT

Original text of this message