hasRole([roleType,] roleName)Security functions
Security functions provide the ability to interact with the security system or to hash/encrypt values.
HASROLE
Whether the current caller has the Teiid data role roleName.
roleName must be a string, the return type is Boolean.
The two argument form is provided for backwards compatibility. roleType is a string and must be `data'.
Role names are case-sensitive and only match Teiid Data roles. Foreign/JAAS roles/groups names are not valid for this function, unless there is corresponding data role with the same name.
MD5
Computes the MD5 hash of the value.
MD5(value)value must be a string or varbinary, the return type is varbinary.
String values are first converted to their UTF-8 byte representation.
SHA1
Computes the SHA-1 hash of the value.
SHA1(value)value must be a string or varbinary, the return type is varbinary.
String values are first converted to their UTF-8 byte representation.
SHA2_256
Computes the SHA-2 256 bit hash of the value.
SHA2_256(value)value must be a string or varbinary, the return type is varbinary.
String values are first converted to their UTF-8 byte representation.
SHA2_512
Computes the SHA-2 512 bit hash of the value.
SHA2_512(value)value must be a string or varbinary, the return type is varbinary.
String values are first converted to their UTF-8 byte representation.
AES_ENCRYPT
aes_encrypt(data, key)AES_ENCRYPT() allow encryption of data using the official AES (Advanced Encryption Standard) algorithm,
16 bytes(128 bit) key length, and AES/CBC/PKCS5Padding cipher algorithm with an explicit initialization vector.
The AES_ENCRYPT() will return a BinaryType encrypted data.
The argument data is the BinaryType data to encrypt, and the argument key is a BinaryType used in encryption.
AES_DECRYPT
aes_decrypt(data, key)AES_DECRYPT() allow decryption of data using the official AES (Advanced Encryption Standard) algorithm,
16 bytes(128 bit) key length, and AES/CBC/PKCS5Padding cipher algorithm expecting an explicit initialization vector.
The AES_DECRYPT() will return a BinaryType decrypted data.
The argument data is the BinaryType data to decrypt, and the argument key is a BinaryType used in decryption.