Revoking privilege at column level failed

Hi,

I'm not an Oracle DBA, but what I tried to do is to revoke Select privilege of
ColumnX of tableY with owner Adams from user Scott.

From Oracle's DBA guide, it takes two steps to accomplish the above: REVOKE privileges on the tbl from the user GRANT ... to the user

No problem with the first step
(REVOKE ALL ON "ADAMS"."SOMEcomplexTBL627" FROM SCOTT)

But, when I issued,
GRANT SELECT ("MILL_24-HHGGSDDRT","MILL_24-D38272SDSFPH","MILL_24-DUWUE3KKRES") ON "SOMEcomplexTBL627" TO SCOTT;
I got an error, msg:
missing ON keyword pointing at between SELECT and (

What's wrong?

Thanks.

DL Received on Tue Jun 11 2002 - 17:21:47 CEST