Re: Assigning select on specific column to a user

From: <meekel_at_yahoo.com>
Date: Fri, 01 Sep 2000 16:10:02 GMT
Message-ID: <8ookc8$rlq$1@nnrp1.deja.com>

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. Received on Fri Sep 01 2000 - 11:10:02 CDT