Barry,
I suggest you open a Tar with Oracle, unless you're sure changing your
application is easy. Oracle obviously missed this little detail by
over-rejecting a previously legitimate role. If 9i's Release note doesn't say
how to deal with this case, then Oracle support should open a bug.
Tom,
It's not always easy to have a futuristic view to avoid potential problems. The
developer probably shouldn't have granted anything to internal back then. But
it wasn't obvious at that time that doing so could cause a problem later.
Yong Huang
- Barry Deevey <barry.deevey_at_enmo.co.uk> wrote:
> This would explain why it worked when I tried it on oracle 8 then.
>
> The developers that originally created the application left quite a while
> ago, so I don't think I'll be able to ask them why they did it this way.
> But basically you're saying that it shouldn't have been done like this and
> now it needs to be changed.
>
> Not the answer I was hoping for, but at least now I know!!
>
> Thanks for your help all.
>
> -----Original Message-----
> Mercadante, Thomas F
> Sent: 18 November 2003 14:54
> To: Multiple recipients of list ORACLE-L
>
>
> Yong,
>
> It seems to me that you are missing the point here. The real point is that
> you should not have granted "select on some table to internal" - ever. And
> a new release caught you on this mistake. And now, you have to fix it. It
> is not an Oracle problem, but a mis-use of an Oracle "internal" user.
>
> What you did implies that you are running sql statements while connected as
> internal. Why in the world you would take this chance is beyond me -
> strictly a no-no.
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -----Original Message-----
> Sent: Tuesday, November 18, 2003 8:59 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Tim,
>
> I checked v$reserved_words. At least in 9.2.0.1, INTERNAL is not in there.
> Oracle should address this issue.
>
> When I trace the SQL GRANT SELECT ON SOMETABLE TO INTERNAL, it stops in
> parsing.
>
> Nonetheless, it's confusing to say the least to create a role called
> internal.
>
> Yong Huang
>
> --- Tim Gorman <tim_at_sagelogix.com> wrote:
> > Barry,
> >
> > Why make life difficult? It's just a role, not a data
> > object referenced by applications (hopefully). Change it's
> > name to something that is not a "reserved word" and move on.
> > There is a list of "reserved words" in the SQL Language
> > reference.
> >
> > Hope this helps...
> >
> > -Tim
> >
> >
> > > Hello all,
> > >
> > > I'm attempting to import into 9.2.0.1.0 from 7.3.4 and I'm
> > > getting loads of the same error:
> > >
> > > IMP-00017: following statement failed with ORACLE error
> > > 9275:
> > > "GRANT SELECT ON "DOWNLOAD_SEQ" TO "INTERNAL""
> > > IMP-00003: ORACLE error 9275 encountered
> > > ORA-09275: CONNECT INTERNAL is not a valid DBA connection
> > >
> > > I'm aware that connect internal does not exist in 9i, but
> > > 'internal' is a role.
> > >
> > > So as a test I dropped the role, recreated it and then
> > > manually tried to grant it something - The same error
> > > occurred:
> > > SQL> select * from dba_roles where role like 'INTER%';
> > >
> > > ROLE PASSWORD
> > > ------------------------------ --------
> > > INTERNAL NO
> > >
> > > SQL>
> > > SQL> drop role internal;
> > >
> > > Role dropped.
> > >
> > > SQL> create role internal;
> > >
> > > Role created.
> > >
> > > SQL> GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL;
> > > GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL
> > > *
> > > ERROR at line 1:
> > > ORA-09275: CONNECT INTERNAL is not a valid DBA connection
> > >
> > > SQL>
> > >
> > > This doesn't make any sense to me. Can anybody help to
> > > shed any light on this??
> > >
> > > TIA for any response, they're much appreciated.
> > >
> > > Cheers,
> > > Barry
>
> __________________________________
> Do you Yahoo!?
> Protect your identity with Yahoo! Mail AddressGuard
> http://antispam.yahoo.com/whatsnewfree
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Yong Huang
> INET: yong321_at_yahoo.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: Mercadante, Thomas F
> INET: NDATFM_at_labor.state.ny.us
>
> 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: Barry Deevey
> INET: barry.deevey_at_enmo.co.uk
>
> 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).
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Yong Huang
INET: yong321_at_yahoo.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).
Received on Tue Nov 18 2003 - 10:49:28 CST
