Oracle 9i query>>help

7 posts · originally from https://geek.digit.in/community/threads/oracle-9i-query-help.49024/

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::

Check your pm.

hey gaurav dude thanks it worked

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

anyway i reped u

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

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

If you want to change your password only:

Code:

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:

Code:

CREATE USER [I]user [/I]
IDENTIFIED BY [I]password[/I];

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

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