Re: Re: Anyone run into this strange ORA-00904 error ??

i believe column privileges are only for dml. views are supposed to filter out columns for selects. i could be wrong.
>
> From: Krishna Kakatur <Krishna.Kakatur_at_Sun.COM>
> Date: 2003/12/02 Tue PM 12:34:26 EST
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: Re: Anyone run into this strange ORA-00904 error ??
>
>
> Did you check grants on the table?
>
> This happens sometimes, with some oracle versions,
> in the following situation:
>
> step1: user1 creates tab1 and
> grants all to user2. (without grant option)
> step2: user2 creates view1 based on tab1
> and grants all to user3.
>
> Now, when user3 tries to access view1 he gets this kind of error.
>
> This can be resolved by issuing the foll sql in step1
>
> GRANT ALL ON tab1 TO user2 WITH ADMIN OPTION;
>
>
> --
> Thanks,
> Krishna
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> NOTICE: This email message is for the sole use of the intended
> recipient(s) and may contain confidential and privileged
> information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the intended
> recipient, please contact the sender by reply email and destroy
> all copies of the original message.
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
>
> > babette.turnerunderwood_at_hrdc-drhc.gc.ca wrote:
> >
> > We started having a weird problem that looks like some kind of data dictionary corruption.
> >
> > My first choice is to run catalog / catproc. This did nothing to resolve the problem.
> >
> > Why am I able to describe an object, but get ORA-00904 when I try to select from the table...
> >
> > SQL> desc ispownre3.individual_names;
> > Name Null? Type
> > ----------------------------------------- -------- ------------------
> > INTERNAL_IDENTIFIER NUMBER(12)
> > TITLE_CD NUMBER(3)
> > . . .
> >
> > SQL> select * from ispownre3.individual_names;
> > select * from ispownre3.individual_names
> > *
> > ERROR at line 1:
> > ORA-00904: invalid column name
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Krishna Kakatur
> INET: Krishna.Kakatur_at_Sun.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <ryan_oracle_at_cox.net
  INET: ryan_oracle_at_cox.net

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).