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