Re: restrict access to columns in a table

"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:25:39 CDT