Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How does one change an Oracle users password?

April 26, 2017Oracle password user

0

Posted

How does one change an Oracle users password?

1 Answer

0

Posted

Issue the following SQL command to change a user’s password: ALTER USER IDENTIFIED BY ; Starting from Oracle 8 you can just type password from SQL*Plus, or if you need to change another user’s password, type password user_name. Look at these examples: SQL> password Changing password for SCOTT Old password: New password: Retype new password: SQL> passw scott Changing password for scott New password: Retype new password: Password changed Note: Oracle usernames and passwords are not case sensitive in database versions below Oracle 11g.