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

"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.

well 8i isn't desupported until the end of the year so you have 9 months to decide what to do.

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

No. And if there were guess what it wouldn't be supported so you've just destroyed your argument for asking.

>
> (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.

fix the app or remain on 8i.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************