As of yet I'm unsure how the application would be affected if I rename the role - I need to do some investigation.
I tried this in Oracle 8 and it worked fine - It just seems to be oracle 9 that doesn't like it. I've also checked v$reserved_words and INTERNAL is not listed, INTERNAL_USE and INTERNAL_CONVERT are. As a test I created roles for INTERNAL_USE and INTERNAL_CONVERT, hoping that it would not allow me to create them, but it did, so I then ran the grant again and it also allowed it. Now I'm really confused!! -----Original Message----- Tim Gorman Sent: 18 November 2003 13:34 To: Multiple recipients of list ORACLE-L 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. > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net -- > Author: Barry Deevey > 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: Tim Gorman 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: Barry Deevey 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).