Re: Grant column
- From: David Sharples <davidsharples@xxxxxxxxx>
- To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 21 Dec 2004 16:59:30 +0000
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@xxxxxxxxxxxxx> 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?
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
