DEVFYI - Developer Resource - FYI

How does one change an Oracle user's password?(for DBA

ORACLE Interview Questions and Answers (Part 4)


(Continued from previous question...)

605. How does one change an Oracle user's password?(for DBA

Issue the following SQL command:
ALTER USER <username> IDENTIFIED BY <new_password>;
From Oracle8 you can just type "password" from SQL*Plus, or if you need to change another user's password, type "password user_name". Look at this example:
SQL> password
Changing password for SCOTT
Old password:
New password:
Retype new password:

(Continued on next question...)

Other Interview Questions