|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
password password username
Allows to (interactively) change the password for the user username. If username is not specified, the password is changed for the user logged on SQL*Plus. Since the password is changed interactively, it seems not possible, at least to me, to change it in an SQL script.
The password can alternatively be changed with the SQL statement alter user USERNAME identified by NEW_PASSWORD.