How do I create "userid" and "password" for SQL*Plus ?

[hiptino]

I'm new to oracle. I've just installed oracle on my standalone PC running WindowsNT.
I'm always prompted for "userid" and "password" to use SQL*Plus.
I created a user from Windows NT user groups as the DBA fro oracle.

Still the user I created is rejected by SQL*Plus.

What should I do ?

 

[Guest_imported]

Log on as system admin
userid is system
password is manager

after which you create user and grant yourself and grant yourself all priviledges.

like grant create table and other.

 

[cmoulee]

hi,
if you install oracle, by default 3 userid will be created

1) userid: sys and password: change_on_install
2) userid: system and password: manager
3) userid: scott and password: tiger

of the three, scott is an ordinary user. whereas sys is the superuser and system is dba.

if you want to create additional users use,
sql>create user username identified by password
sql>grant rolename to user