Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to create an user "INTERNAL" in Oracle9i ???

How to create an user "INTERNAL" in Oracle9i ???

From: Lukas Unterasinger <Lukas.Unterasinger_at_akh-wien.ac.at>
Date: Tue, 16 Mar 2004 18:02:02 +0100
Message-ID: <405732ca$0$29350$3b214f66@usenet.univie.ac.at> 





Our problem:



We are using several programs which are connecting to Oracle-DB(8i) 
hardcoded as User "INTERNAL".


We have to upgrade to Oracle.9i (support-by-Oracle) Database and must 
use the old programms to fill it. We can not edit the code and compile 
it ! So the CONNECT as INTERNAL command must work on new oracle-version.



Question:


Is there any way to create an user "INTERNAL" with privileges like "SYS" 
in Oracle 9i to use the CONNECT as INTERNAL command ?



(we can not use the sqlplus \nolog instead because we can not edit the 
filling-program)



Please give an idea. Thank you very much in advance.



Best Regards,


Lukas Unterasinger
Received on Tue Mar 16 2004 - 11:02:02 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US