user_set_password
Allows dba to change a user's password.
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 comfirmation, 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
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 |