Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Assigning select on specific column to a user
Can't do ...
Only the INSERT, UPDATE, and REFERENCES privelges can specify a column name (or list of columns); you cannot GRAQNT the SELECT privelege to a user or role on a specific column(s); the SELECT privelege always applies to an entire table or view.
Of possible solutions, defining a view with only those column(s) to which you want to allow SELECT is easiest ....
anasuya_shukla_at_my-deja.com wrote:
>
> Thanks for the input.
> But I want to restrict 'select' as well.
>
> I revoked select from the table and tried to grant select
> on specific columns.
>
> DID not work .
>
> Ana
>
> In article <8ookc8$rlq$1_at_nnrp1.deja.com>,
> meekel_at_yahoo.com wrote:
> >
> >
> > grant update (columnname,columnname,etc...) on schema.tablename to
> > user/role;
> >
> > In article <8oohld$o9v$1_at_nnrp1.deja.com>,
> > anasuya_shukla_at_my-deja.com wrote:
> > > Hi,
> > >
> > > I keep getting the error message "missing ON keyword"
> > > when trying to grant select,update ..etc on a specific column
> > > in a table to a user.
> > > The Oracle 8i books suggest:
> > > GRANT UPDATE (dname) ON dept TO human_resources;
> > >
> > > But this gives me the above error message.
> > > Any help will be much appreciated.
> > >
> > > I am using Oracle 8.1.5.
> > >
> > > Ana
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> > >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Sep 05 2000 - 16:20:30 CDT