>From documentation: "You can specify columns only when granting the
INSERT, REFERENCES, or UPDATE privilege.".
On Tue, 21 Dec 2004 10:48:11 -0600, DENNIS WILLIAMS
<DWILLIAMS_at_lifetouch.com> wrote:
> According to the 9i documentation, you can now grant a column in a table to
> another user. I can't seem to get the syntax correct. Here is what the fine
> manual seems to indicate:
>
> GRANT SELECT (COLUMN1) ON TABLE1 TO USER1;
>
> *
>
> ERROR at line 1:
>
> ORA-00969: missing ON keyword
>
> I've tried different syntax combinations with no luck. Has anyone else
> succeeded at this?
>
> Dennis Williams
>
> DBA
>
> Lifetouch, Inc.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
--
Edgar
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Dec 21 2004 - 11:04:33 CST
