syntax?

[Desi-racie]

Hi everybody!

I am a baby-level user.
to create users I used:

create user Jim Huges
create user Tom Jones

is this okay?

Bye!

[skhanal]

The syntax depends on DBMS you are using.

[Desi-racie]

Hi skhanal,

I use SQL*Plus (Oracle8).

Thanks so far

[MAK]

create user MyUser identified by mypassword;

[skhanal]

For the user to login you have to

GRANT CONNECT to myuser;
GRANT CREATE SESSION to myuser;