Grant column

  • From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
  • To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 21 Dec 2004 10:48:11 -0600

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

Other related posts: