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: grant select on columns

Re: grant select on columns

From: Vrajesh Patel <vrajesh_p_at_hotmail.com>
Date: Fri, 23 Jul 1999 15:19:23 GMT
Message-ID: <%J%l3.80$%L2.11051@PM01NEWS>


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

Original text of this message

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