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  [I]user[/I]
IDENTIFIED  [I]password[/I];

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 [I]user [/I]
IDENTIFIED BY [I]password[/I];

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

 

[vinit suri]

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