Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: restrict access to columns in a table

Re: restrict access to columns in a table

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 28 Apr 2004 16:25:39 -0700
Message-ID: <2687bb95.0404281525.6181bbc9@posting.google.com>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US