Friday, 8 July 2011

Oracle - Change user password

There are two different methods for changing a users password. The user is able to do it themselves using the following:
SQL> password
Changing password for <username>
Old password:
New password:
Retype new password:
Password changed
SQL>
Or as sysdba you can do the following:
SQL> alter user <usernamer> identified by <password>;
User altered.

No comments:

Post a Comment

Please feel free to leave a comment