Re: Grant column

From: David Sharples <davidsharples_at_gmail.com>
Date: Tue, 21 Dec 2004 16:59:30 +0000
Message-ID: <be592d550412210859757b5e26@mail.gmail.com>

SQL> grant update(username) on users to xxx;

Grant succeeded.

SQL> grant select(username) on users to xxx; grant select(username) on users to xxx

*
ERROR at line 1:
ORA-00969: missing ON keyword

weird huh!, i can update but not select

On Tue, 21 Dec 2004 10:48:11 -0600, DENNIS WILLIAMS <DWILLIAMS_at_lifetouch.com> wrote:

>
> 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?

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 21 2004 - 10:59:12 CST