Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Grant column
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-lReceived on Tue Dec 21 2004 - 10:49:14 CST
![]() |
![]() |