SYSTEM$START_USER_EMAIL_VERIFICATION¶

Syntax¶

SYSTEM$START_USER_EMAIL_VERIFICATION( '<user_name>' )

Arguments¶

'user_name'

Name of the user.

Access control requirements¶

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

Usage notes¶

• 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:

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

  Copy

Examples¶

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');

Start email verification for a user with a case-sensitive name:

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