Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Grant column

RE: Grant column

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 21 Dec 2004 12:41:24 -0500
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF410511E6EA@usahm236.amer.corp.eds.com>


The ability to do column level DML grants is not a new feature. On a developers desk I found an old Oracle7 Server SQL manual (Dec. 1992) and the syntax is there. Part number 778-70-1292, pg 4-311.

HTH -- Mark D Powell --

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of DENNIS WILLIAMS Sent: Tuesday, December 21, 2004 12:14 PM To: Edgar Chupit
Cc: Oracle-L
Subject: RE: Grant column

Thanks Edgar, David, Raj, everyone.

Any speculation why Oracle got stingy on the SELECT? I guess I can see maybe there are times where creating a view might interfere with update or insert. Just seems like SELECT would have been easy to include while they were coding this change. Does anyone know if this feature was added for ANSI compatibility?

Dennis Williams
DBA
Lifetouch, Inc.

-----Original Message-----
From: Edgar Chupit [mailto:chupit_at_gmail.com] Sent: Tuesday, December 21, 2004 11:04 AM To: DENNIS WILLIAMS
Cc: Oracle-L
Subject: Re: Grant column

>From documentation: "You can specify columns only when granting the
INSERT, REFERENCES, or UPDATE privilege.".

On Tue, 21 Dec 2004 10:48:11 -0600, DENNIS WILLIAMS <DWILLIAMS_at_lifetouch.com> wrote:
> 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
>

-- 
  Edgar

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US