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: Turkbear <john.g_at_dot.spamfree.com>
Date: Tue, 16 Mar 2004 16:03:14 -0600
Message-ID: <39ue509g0if4t4ebc2s53cfckahodbnp6k@4ax.com>


Lukas Unterasinger <Lukas.Unterasinger_at_akh-wien.ac.at> wrote:

>Turkbear wrote:
>
>> Lukas Unterasinger <Lukas.Unterasinger_at_akh-wien.ac.at> 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
>>
>>
>> I realise that this is not an answer, but why on earth would any application log in as INTERNAL?!? That should be used only
>> for DBA startup and shutdown tasks. Use System for the other instance wide actions..
>>
>> 9i requires that any login that needs SYSDBA or SYSOPER privs use the
>> connect user/password_at_instance AS SYSDBA ( or AS SYSOPER) format.
>>
>> I am not sure 9i will even allow you to cerate a user called INTERNAL and grant DBA privs to it..
>>
>But exactly that is the problem !
>Is there any trick/way
>one in this NG knows to create an user called INTERNAL ?
>(it can not be done like creating any other user !
>But may be if at installation .... or using secret flags ... ;-| ???)
>
>Best Regards,
>Lukas Unterasinger

I cannot use a 1995 Lexus engine in a 2004 model, you can't use Internal in 9i..It only works on older versions ....My question remains, what kind of app is this that is using such a bad way to connect? Received on Tue Mar 16 2004 - 16:03:14 CST

Original text of this message

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