Re: restrict access to columns in a table

From: Pedro Lopes <pedro.lopes_at_netvisao.pt>
Date: Thu, 29 Apr 2004 00:42:16 +0100
Message-ID: <newscache$9xmwwh$tg8$1@newsfront4.netvisao.pt>

In 10g you can use VPD (virtual private database) with column level restricions with or without column masking.

search the documentation for column-level VPD in the security guide in http://tahiti.oracle.com

hope it helps,
pedro.

Mark D Powell wrote:

> "Cookie Monster" <cookie.monster_at_somewhere.com> wrote in message news:<c6ndun$e1nac$1_at_ID-82797.news.uni-berlin.de>...
> 

>>Hi,
>>
>>Is there any way to limit the access a user has to columns in a table
>>without using a view. ie. the user enters:
>>
>>select * from emp;
>>
>>and only the emp_id column is returned.
>>
>>I just need to restrict access to columns but don't want to create lots of
>>views.
>>
>>Thanks,
>>Cookie.

> 
> 
> I think views are your only real option.  You can restrict object
> privileges to columns for update and references, but I do not believe
> you can do so for selects at least in 9.2 where I tested.
> 
> HTH -- Mark D Powell --

Received on Wed Apr 28 2004 - 18:42:16 CDT