oracle change password for user

If i have a user name bill how do i change his password using sql
LVL 4
Brant SnowAsked:
Who is Participating?
 
sventhanConnect With a Mentor Commented:
alter user user_name identified by new_password;

user_name is the user whose password you wish to change.

new_password is the new password to assign.

http://www.techonthenet.com/oracle/password.php
0
 
sventhanCommented:
alter user bill identified by bill  --- bill is the password
0
 
sventhanCommented:
if you want to expire the password after the first login....

alter user bill identified by yourpassword password expire
0
 
Brant SnowAuthor Commented:
alter user jeff identified by 83ios32S

i do that but i get a
SQL Error: ORA-00922: missing or invalid option
00922. 00000 -  "missing or invalid option"
*Cause:    
*Action:

can a user alter their own password, in other words if i am logged in as jeff can i still alter my password as long as he has the correct priveledges
0
 
Brant SnowAuthor Commented:
never mind i just had a bad character in the password i made works great
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.