Re: Disallow access to column of a table
- From: Mathias Magnusson <mathias.magnusson@xxxxxxxxx>
- To: JBECKSTROM@xxxxxxxxx
- Date: Mon, 5 Oct 2009 21:59:09 +0200
Why not use a view where you skip the columns that should not be accessed
and then grant access to the view to the user(s) that should have limited
view and make sure they have no access to the table?
Mathias
On Mon, Oct 5, 2009 at 9:35 PM, Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx>wrote:
> 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:
