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>
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