Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: grant select on columns
Hi.
I don't think that you can make grants specific down to the column level in Oracle. What you could do is create a view, which selects these 2 columns from the table, and grant select on the view to your user.
Hope this helps,
-Jeff Guttadauro
On Fri, 23 Jul 1999 14:22:09 +0100, "Rüdiger J. Schulz" <r.schulz_at_berlin.de> wrote:
>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 - 08:15:35 CDT