Skip to main content
Version: 0.0.25

Method: set_user_password_request

Method for requesting a new password for an IAM user

Accepts the following parameters:

  • username: the name of the IAM user to manage
  • password: the new password to set for the user. If password is set to blank it will delete the current password
  • reset_password: a value of 'true' will require the user to update the password in the next login

Returns following columns:

  • status: OK if the password was updated successfully
  • message: Error message in case of failure

Example

SELECT * FROM set_user_password('user', 'password', true);

See