Oracle-L: 'internal' role and 9i

From: Barry Deevey <barry.deevey_at_enmo.co.uk>
Date: Tue, 18 Nov 2003 05:04:25 -0800
Message-ID: <F001.005D70CC.20031118050425@fatcity.com>

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