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).
Received on Tue Nov 18 2003 - 07:59:25 CST
