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
Jeff,
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@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:
