[Q] grant select on "column level security" failed?

From: dist cash <mccdba_at_hotmail.com>
Date: Wed, 29 Jan 2003 07:24:48 -0800
Message-ID: <F001.0053D4CE.20030129072448@fatcity.com>

I tried to grant "select" on "column level security" and failed (on 8.1.7 and 9.2). I heard some said "column level security" on work on "insert update and reference". Is it true? any other way to pass around?

  SQL> grant select (update_date) on pay_update to user1; grant select (update_date) on pay_update to user1

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

SQL> grant update (update_date) on pay_update to user1;

Grant succeeded.

Thanks.

---

The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: dist cash
  INET: mccdba_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jan 29 2003 - 09:24:48 CST