Re: Assigning select on specific column to a user

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 - 14:08:25 CDT