RE: Grant column
- From: "Gogala, Mladen" <MGogala@xxxxxxxxxxxxxxxxxxxx>
- To: "'DWILLIAMS@xxxxxxxxxxxxx'" <DWILLIAMS@xxxxxxxxxxxxx>, Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 21 Dec 2004 12:26:46 -0500
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@xxxxxxxxxxxxx]
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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
