Oracle 9i query>>help

[::cyborg::]

hi guys,

iam realy having a frustrating problem

when installing oracle 9i i dont know what password i entered at that time but now when iam trying to login to sql*plus a/c iam not able to do so.

it asks me three things
1)username
2)password and
3)string which i really dont know

plz help me iam a newbie .plz help.

helpppppp

::cyborg::

[gaurav_indian]

Check your pm.

[::cyborg::]

hey gaurav dude thanks it worked

and gauav what if i want my user name and password to be there

anyway i reped u

[vinit suri]

try this man
username: scott
password : tiger
n leave the string blank...
k
also try
username: sys
password : manager
.best of luck

[::cyborg::]

@vinit scott tiger is ok but sys manager is not working

[Lucky_star]

If you want to change your password only:

ALTER USER  user
IDENTIFIED  password;

user is the name of the existing user and password is the new password which is to be specified.
For Ex.
ALTER USER scott
IDENTIFIED BY cat;
User Altered

If you want to create a new user with a new password, then:

CREATE USER user 
IDENTIFIED BY password;

For using that user id You have to grant certain roles and privileges

[vinit suri]

[tats right create new user......best of luck