RE: 'internal' role and 9i

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: 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).