Tuesday, January 15, 2013

Oracle Change Password

You can change your password with the following sql command.

alter user user_name  identified by new_password ;

or

 alter user user_name  identified by new_password replace old_password;

If you want to include special characters in the password, mention the new password in quotes.

eg:
alter user scott identified by "NewYear20!2" replace "Winter20!2";

No comments:

Post a Comment