How to change oracle user password?  

Tuesday, June 9, 2009

Question: How to change oracle user password?

Answer:

The syntax is:

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.

For eg:
I wanted to update system user password to helloworld

SQL> alter user system identified by helloworld;

User altered.

AddThis Social Bookmark Button
Email this post


Design by Amanda @ Blogger Buster