ALTER USER
Changes the user password.
Syntax:
ALTER USER user_name [ WITH ] option [ ... ]
user_name
: The name of the user.option
: The password of the user:PASSWORD 'password'
creates a user with thepassword
password. TheENCRYPTED
option is always enabled.PASSWORD NULL
creates a user with an empty password.