Name
user_set_password — Allows dba to change a user's password.
Synopsis
user_set_password ( |
in user_name string , |
in new_password string
) ; |
Description
Explicitly sets a new password for the SQL account user_name
to new_password
. Only users in the dba
group may execute this function. It allows the database
administrator to reset lost passwords of SQL accounts. The new
password will be set without further confirmation, so the DBA must
be sure of the new password.
Parameters
user_name
SQL user account name to change.
new_password
New password for the user as plain text.
Errors
Parameter data type checking errors
Table24.106.Errors signalled
by user_set_password()
SQL Code | Error Message | Virtuoso Code |
---|---|---|
42000 | Function user_set_password restricted to dba group | SR285 |
42000 | The user <user_name> does not exist | SR286 |
42000 | The new password for <user_name> cannot be empty | SR287 |