Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Grant column

Grant column

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Tue, 21 Dec 2004 10:48:11 -0600
Message-ID: <DFA54221DF26D911BC5100B0D079D97A019B6D1C@exchmn5>


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
Received on Tue Dec 21 2004 - 10:49:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US