[Oracle] Changing your user password

Changing the user password on an Oracle instance is easier than I thought.

SQL> alter user <username/schema-name> identified by <new-password>;

Where username/schema-name is the name of the user you would like to change. And, new-password is the new password for username. For example to change the user ‘john’ password to ‘calvin’ perform:

SQL> alter user john identified by calvin;

Alternatively, at the SQL prompt you could just type ‘passwd’, which will interactively walk you through changing the password as the currently connected user. To change the passwd for another use, supply that username as an argument to ‘passwd’. This works the same was ‘passwd’ is used on Unix systems. Here’s an example:

SQL> password
Changing password for JOHN
Old password: 
New password: 
Retype new password: 
Password changed
SQL> 
Advertisements
This entry was posted in Oracle. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s