i believe column privileges are only for dml. views are supposed to filter out columns for selects. i could be wrong. > > From: Krishna Kakatur <[EMAIL PROTECTED]> > Date: 2003/12/02 Tue PM 12:34:26 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > 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. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > > > > [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
