Re: oracle 8i user creation problem

Intrigued as to why you'd want to do this in the first place, nevertheless if you want an equivalent of SYS, simply issue the 'grant sysdba to fred' command. For that to work, you must have remote_login_passwordfile set to 'EXCLUSIVE' in your init.ora, and there must actually *be* a password file. Once done, however, fred will be able to log on thus: connect fred/usualoldpassword AS SYSDBA. And he will find himself an exact equivalent of the user SYS.

Actually, he won't be an *equivalent* of the user SYS.... he will actually *BE* connected as SYS, as a quick check of 'select user from dual' will reveal.

Indeed, try select user from dual when *you* are connected as Internal, too.... you'll find your connected as SYS as well.

From which you should deduce that the attempt to create a User that looks and feels like SYS is a waste of time, and probably impossible.

Regards
HJR "peanutp" <peter.ashford_at_nospamblueyonder.co.uk> wrote in message news:3a992d53_at_news.telinco.net...
> Hello,
>
> When creating a duplicate user with the same profile etc.. as "sys" the
> following error occurs, "Ora-06553:PLS-213:package STANDARD not
 accessible".
> I am using oracle 8i 8.1.6.0.0 on win2k ad server
> using dba studio to create the user
> logged in as "internal" to create the user -also tried with the "sys"
 user,
> but the same error occurs.
> I am new to oracle, so excuse any silly mistakes i may have made.
>
> any help is welcome.
>
>
Received on Sun Feb 25 2001 - 12:51:51 CST