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