CTP UDFs

CipherTrust Teradata Protection (CTP) supports several user-defined functions (UDFs) to perform encryption and decryption operations on the Teradata database. This chapter contains the following sections:

• Invoking the UDFs

• Mode Recommendations

• encrypt_cbc()

• decrypt_cbc()

• encrypt_int()

• decrypt_int()

• encrypt_byteint()

• decrypt_byteint()

• encrypt_smallint()

• decrypt_smallint()

• encrypt_date()

• decrypt_date()

• encrypt_time()

• decrypt_time()

• encrypt_timestamp()

• decrypt_timestamp()

• encrypt_fpe()

• decrypt_fpe()

• encrypt_fpe_int()

• decrypt_fpe_int()

• encrypt_fpe_byteint()

• decrypt_fpe_byteint()

• encrypt_fpe_smallint()

• decrypt_fpe_smallint()

• encrypt_ff1()

• decrypt_ff1()

• encrypt_ff1_int()

• decrypt_ff1_int()

• encrypt_ff1_byteint()

• decrypt_ff1_byteint()

• encrypt_ff1_smallint()

• decrypt_ff1_smallint()

• encrypt_string()

• decrypt_data()

• encrypt_char()

• decrypt_char()

• profiles.conf

• Data Masking for Encryption and Decryption