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
Table 24.105. 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 |