Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: grant select on columns
Grant on column level can be given on update and insert level. You can give
a column level grant for select privs.
Thanks,
-Vrajesh Patel
Rüdiger J. Schulz <r.schulz_at_berlin.de> wrote in message
news:37986C81.981D11CC_at_berlin.de...
> hi all,
>
> I try to grant select on columns to a user with
>
> GRANT select (field1, field2) ON schema1.table1 TO user;
>
> but oracle dont want to give the grant.
> what's wrong?
>
> R.J. Schulz
>
Received on Fri Jul 23 1999 - 10:19:23 CDT