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: [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: Joe Testa 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).