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

Lukas Unterasinger wrote:

> 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

Bad design decisions always require a price to be paid later. Time to pay that price. As Turkbear said ... this should never have been done in the first place.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)