RE: Did column-level grants go away?
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <bbellows@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 24 Jun 2005 21:20:03 +0200
Hi Bambi,
granting the select privilege at the column level was never implemented by
Oracle, although I believe the data dictionary "kind of" always suggested the
possibility. I quickly checked my old SQL reference manuals, but even in version
5 only the UPDATE privilege is documented as allowing you to specify it at the
column level.
kind regards,
Lex.
------------------------------------------------------------------
Steve Adams Seminar http://www.naturaljoin.nl/events/seminars.html
------------------------------------------------------------------
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Bellows, Bambi
Sent: Friday, June 24, 2005 20:25
To: oracle-l@xxxxxxxxxxxxx
Subject: Did column-level grants go away?
Friends --
You know, it's not something that comes up everyday, but, back in v5, you used
to be able to do column level grants... that is to say:
grant select on tabl(col1, col3, col5) to userX;
I seem to recall it being there in v6 too.
And the band played on, and time passed, and now here we are in v9.2.0.5, and a
user sent me an email saying "how do I do column level grants?". Well, having
an extraordinary memory, I reply, "why, that's easy, just do a grant on
tab1(col1, col3, col5) to userX;", but, before I send that email, I decide to
test my extraordinary memory and just try it. And a good thing, too, because it
didn't work. So, I decide to check syntax in the online documentation, and it's
not there. Then, being a computer professional, I go to google, and I enter
"column level grants", and of course, Burleson's site comes up with a script to
recreate them (pay $39.95!) and a whole bunch of sites that say, basically, that
just isn't possible.
So, is it possible or not, or did the syntax just change, and if it's gone,
whehn did it happen and why in the world did Oracle think that was a good idea?
Thanks all!
Bambi.
--
//www.freelists.org/webpage/oracle-l
BEGIN:VCARD
VERSION:2.1
N:de Haan;Lex
FN:Lex de Haan
ORG:Natural Join B.V.
TEL;WORK;VOICE:+31.30.2515022
TEL;HOME;VOICE:+31.30.2518795
TEL;CELL;VOICE:+31.62.2955714
TEL;WORK;FAX:+31.30.2523366
ADR;WORK:;;Pieter Breughelstraat 10;Utrecht;;3583 SK;Netherlands
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Pieter Breughelstraat 10=0D=0AUtrecht 3583
SK=0D=0ANetherlands
URL;WORK:http://www.naturaljoin.nl
EMAIL;PREF;INTERNET:lex.de.haan@xxxxxxxxxxxxxx
REV:20040224T160439Z
END:VCARD
Other related posts:
