Re: Revoking privilege at column level failed

I just don't understand, why on IBM DB2 NG, every posting of mine got anwsered while this one seems SO difficult, why? DL

donlcs_at_yahoo.com (DL) wrote in message news:<604bb90c.0206110721.538cd457_at_posting.google.com>...
> 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 Wed Jun 12 2002 - 06:05:54 CEST