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

> > You cannot create a user called INTERNAL in an Oracle 9i database. See
> > the following:
> >
> > ORA9I SQL> create user internal identifed by abc123;
> > create user internal identifed by abc123
> > *
> > ERROR at line 1:
> > ORA-09275: CONNECT INTERNAL is not a valid DBA connection
> >
> may there is a command like:
> create user bufferuser alias internal ide...
> grant username ...

Maybe there is a command like:

CREATE USER superman IDENTIFIED BY loislane

   WITH server_root PRIVILEGES
   PLUS able_to_leap_tall_buildings+faster_than_a_speeding_bullet    UNRESTRICTED IN ANY WAY IN ANY UNIVERSE; But it simply doesn't exist.

> 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 ... ;-| ???)

There is a parameter called BYPASS_ALL_SECURITY_MECHANISMS that you could set to TRUE. Just kidding.

Seriously, it was a design flaw to code the application using CONNECT INTERNAL. Most likely, this was done because it made someone's life easier, rather than do it the proper way. The INTERNAL user was announced as being deprecated a very long time ago. This application should have been fixed a long time ago. Why can't you modify your application? Sorry to say, but if you can't modify the application, then it can't be used to connect to an Oracle 9i database. IMO, it is better to fix the broken design than to continue to use it in this manner.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"