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>
Date: Tue, 5 Jun 2001 00:30:27 +0200
Message-ID: <9fh265$1kdt$1_at_as201.hinet.hr>
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
"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