Switch to: V9V8V7V6V5

SET PASSWORD

[new v9.0]

Syntax

set_password_statement
    :    SET PASSWORD OF [USER] username IDENTIFIED BY old_password TO new_password 

Description

This command allows you to change the password of an existing user.

Examples

Example:

SET PASSWORD OF USER user1 IDENTIFIED BY 'password' TO 'new_password';