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