Re: Grant column
- From: Edgar Chupit <chupit@xxxxxxxxx>
- To: DWILLIAMS@xxxxxxxxxxxxx
- Date: Tue, 21 Dec 2004 19:04:23 +0200
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@xxxxxxxxxxxxx> 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.
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
Edgar
--
//www.freelists.org/webpage/oracle-l
Other related posts:
