RE: Grant column

From: Gogala, Mladen <MGogala_at_allegientsystems.com>
Date: Tue, 21 Dec 2004 12:26:46 -0500
Message-ID: <D42C14B2E3F2B74DB41D5B6B2E2B992F01931FC6@pegasus.lawaudit.com>

Dennis, you can do that only for the privileges for which it actually makes sense (tough requirement, I know). Here is an example:
SQL> grant select(id) on ven_be to public; grant select(id) on ven_be to public

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

SQL>
SQL> grant references (id) on ven_be to public;

Grant succeeded.

SQL> select * from v$version;

BANNER

---

Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production PL/SQL Release 9.2.0.5.0 - Production
CORE 9.2.0.6.0 Production
TNS for Solaris: Version 9.2.0.5.0 - Production NLSRTL Version 9.2.0.5.0 - Production

SQL>
--

Mladen Gogala
Ext. 121

-----Original Message-----

From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM] Sent: Tuesday, December 21, 2004 11:48 AM To: Oracle-L
Subject: Grant column

According to the 9i documentation, you can now grant a column in a table to another user. I can't seem to get the syntax correct. Here is what the fine manual seems to indicate:  

GRANT SELECT (COLUMN1) ON TABLE1 TO USER1;                *

ERROR at line 1:

ORA-00969: missing ON keyword  

I've tried different syntax combinations with no luck. Has anyone else succeeded at this?  

Dennis Williams

DBA Lifetouch, Inc.

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Dec 21 2004 - 11:25:57 CST