Categories:

System functions (System Control)

SYSTEM$START_USER_EMAIL_VERIFICATION¶

Starts the email verification process for a user. The system sends a verification email to the user’s email address.

语法

SYSTEM$START_USER_EMAIL_VERIFICATION( '<user_name>' )

实参

'user_name'

用户的名称。

访问控制要求

Only the specified user or the role with the OWNERSHIP privilege on that user can call this function.

使用说明

• user_name is a string literal that must be enclosed in single quotes.

  If the user name is case-sensitive or includes any special characters or spaces, you must enclose the name in double quotes, and then enclose the resulting double-quoted name in single quotes. For example:

  Copy codeExpand code block

  SELECT SYSTEM$START_USER_EMAIL_VERIFICATION(
    '"Case-Sensitive UserName"');

  Show lessSee more

  Scroll to top

示例

Start email verification for a user when the user name follows the rules for unquoted object identifiers:

SELECT SYSTEM$START_USER_EMAIL_VERIFICATION('user_name');

开始对名称区分大小写的用户进行电子邮件验证：

SELECT SYSTEM$START_USER_EMAIL_VERIFICATION('"UserName"');