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 -> Re: How to create an user "INTERNAL" in Oracle9i ???

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

From: Paul Drake <drak0nian_at_yahoo.com>
Date: 16 Mar 2004 18:52:38 -0800
Message-ID: <1ac7c7b3.0403161852.6062a545@posting.google.com>


Lukas Unterasinger <Lukas.Unterasinger_at_akh-wien.ac.at> wrote in message news:<405732ca$0$29350$3b214f66_at_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

what would you have done had oracle not postponed the de-support date for 8.1.7 back in late October (simmer)? Were you not sweating this for Q3 2003 also?

Pd Received on Tue Mar 16 2004 - 20:52:38 CST

Original text of this message

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