A collection of scripts, errors & resolutions, and code snippets ranging from daily DBA tasks to Linux Administration, to web design using the new HTML5 and CSS3.
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