Re: 'internal' role and 9i

sounds hardcoded in the kernel about the internal user, reserved word or not, its just a bad idea.

joe

Barry Deevey wrote:

>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: 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).
>>
>>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Tim Gorman
> INET: tim_at_sagelogix.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: Joe Testa
  INET: oracle-l_at_oracle-dba.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).