How To Change User Password

Q

How To Change User Password? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges

✍: FYIcenter.com

A

If you want to change a user's password, you can log in as SYSTEM and use the ALTER USER command as shown in the following example:

>.\bin\sqlplus /nolog

SQL> connect SYSTEM/fyicenter
Connected.

SQL> ALTER USER DEV IDENTIFIED BY beginner;
User altered.

Note that ALTER is SQL statement, so you need to terminate it with ";". This command resets DEV's password to "beginner".

2007-05-02, 4766👍, 0💬