Database Error Messages

Release
toggle
  • 23ai
  • 21c
Updated
Jun 24, 2024

DIA-28220

invalid schema name string or password verification function string

Cause

A nonexistent or invalid schema name or password verification function was specified. This occurred when you attempted to create or alter a profile with PASSWORD_VERIFY_FUNCTION parameter value containing a non-SYS user owned schema qualified function and either of the following was true:

  • The ALLOWED_PVF_OWNERS system parameter was not configured to allow schema qualified password verification function.
  • The user schema was not allowed to own the password verification function.
  • The password verification function was created as an INVOKER rights PL/SQL function.

Action

Specify a valid schema name or password verification function for PASSWORD_VERIFY_FUNCTION parameter. Depending on the error, either one of the following should be done:

  • If the ALLOWED_PVF_OWNERS system parameter is set to NULL (default value), please contact your database administrator to have it set it to an appropriate value (comma separated list of database users) to allow schema qualified password verification function.
  • If the user schema is not allowed to own the password verification function, please contact your database administrator to add the user as part of ALLOWED_PVF_OWNERS system parameter value. Only users specified as ALLOWED_PVF_OWNERS system parameter value are allowed to own password verification function.
  • If the password verification function is created as an INVOKER rights PL/SQL function, please create it as DEFINER rights PL/SQL function and retry {CREATE|ALTER} PROFILE operation. INVOKER rights PL/SQL functions are not allowed as password verification function due to security reasons.