5.6.1 User-Defined Function Reference
The following table lists each user-defined function and provides a short description of each one. For a table listing SQL functions and operators, see Section 12.1, “Function and Operator Reference”
Table 5.5 User-Defined Functions
Name | Description |
---|---|
audit_log_encryption_password_get() |
Fetch audit log encryption password |
audit_log_encryption_password_set() |
Set audit log encryption password |
audit_log_filter_flush() |
Flush audit log filter tables |
audit_log_filter_remove_filter() |
Remove audit log filter |
audit_log_filter_remove_user() |
Unassign audit log filter from user |
audit_log_filter_set_filter() |
Define audit log filter |
audit_log_filter_set_user() |
Assign audit log filter to user |
audit_log_read() |
Return audit log records |
audit_log_read_bookmark() |
Bookmark for most recent audit log event |
gen_blacklist() |
Perform dictionary term replacement |
gen_dictionary() |
Return random term from dictionary |
gen_dictionary_drop() |
Remove dictionary from registry |
gen_dictionary_load() |
Load dictionary into registry |
gen_range() |
Generate random number within range |
gen_rnd_email() |
Generate random email address |
gen_rnd_pan() |
Generate random payment card Primary Account Number |
gen_rnd_ssn() |
Generate random US Social Security number |
gen_rnd_us_phone() |
Generate random US phone number |
keyring_aws_rotate_cmk() |
Rotate AWS customer master key |
keyring_aws_rotate_keys() |
Rotate keys in keyring_aws storage file |
keyring_key_fetch() |
Fetch keyring key value |
keyring_key_generate() |
Generate random keyring key |
keyring_key_length_fetch() |
Return keyring key length |
keyring_key_remove() |
Remove keyring key |
keyring_key_store() |
Store key in keyring |
keyring_key_type_fetch() |
Return keyring key type |
load_rewrite_rules() |
Rewriter plugin helper routine |
mask_inner() |
Mask interior part of string |
mask_outer() |
Mask left and right parts of string |
mask_pan() |
Mask payment card Primary Account Number part of string |
mask_pan_relaxed() |
Mask payment card Primary Account Number part of string |
mask_ssn() |
Mask US Social Security number |
mysql_firewall_flush_status() |
Reset firewall status variables |
normalize_statement() |
Normalize SQL statement to digest form |
read_firewall_users() |
Update firewall user cache |
read_firewall_whitelist() |
Update firewall recorded statement cache |
set_firewall_mode() |
Establish firewall user operational mode |
version_tokens_delete() |
Delete tokens from version tokens list |
version_tokens_edit() |
Modify version tokens list |
version_tokens_lock_exclusive() |
Acquire exclusive locks on version tokens |
version_tokens_lock_shared() |
Acquire shared locks on version tokens |
version_tokens_set() |
Set version tokens list |
version_tokens_show() |
Return version tokens list |
version_tokens_unlock() |
Release version tokens locks |