Access control at column level

From: DL <donlcs_at_yahoo.com>
Date: 9 May 2002 13:03:08 -0700
Message-ID: <604bb90c.0205091203.49f2ff01_at_posting.google.com>


Hi,

I don't have handy access to Oracle manual, the following command generated an error:

REVOKE SELECT [and/or other privilege] (col1) ON DBOWNER.TBLNAME
FROM USERa

err msg:
revoke select (col1)

              *
ERROR at line 1:
ORA-00969: missing ON keyword

btw, the current user has the privilege to grant/revoke privileges on all objects.

Thanks.

DCL Received on Thu May 09 2002 - 22:03:08 CEST

Original text of this message