Re: problem in creating user

From: (wrong string) Ðigas <tdj.bip_at_tel.hr>
Date: Tue, 5 Jun 2001 00:30:27 +0200
Message-ID: <9fh265$1kdt$1_at_as201.hinet.hr>


DBA Studio seems a bit unstable at the time being. If it matures soon, there's still hope. Anyway, it's performance is not always predictable.

For just adding users, use the following statements as SYSTEM, from SQLPlus:

create user USER identified by PASSWORD; grant connect, create session, ROLE3, ROLE_X to USER;

to check users, run select * from all_users;

For more info refer to system docs!

BTW, try EZSQL tool! www.ezsql.org

Hope this helps, cheers!

Tomislav

"Yi Zhang" <yzhang_at_cv.net> wrote in message news:3B02D7A8.D48FF117_at_cv.net...
> Hello:
>
> I appreciate if anyone can help for my problem in creating users.
> I used dba studio to create users, when I create one, there are three
> users with same same will be listed.
> In the users list, there are three users with same name in every one,
> like system, sys and so on.
>
> Thanks
>
> -Roy
>
Received on Tue Jun 05 2001 - 00:30:27 CEST

Original text of this message