How to call direct UDFs for FPE algorithms
Note
The user running a command line UDF must be mapped to the owner of the key (passed as a parameter) in the UDF.
Versioned keys are not supported with FPE algorithms.
Direct Call to dbo.ing_e_nvc_cl_fdb420
SELECT dbo.ing_e_nvc_cl_fdb420
('112236276342649837947333444444444555555555555555555555564', /* inputData */
'yourMetaDatabaseName', /* metadb */
'yourKey', /* keyName */
'FPE/CARD10', /* algorithm/cardinality used */
'SHA1:12', /* Padding used */
0x040103000304060409030103070502050503050704010808010202070402070201030407040009
0105020603000002020906070004010200) /* iv */
AS ENCRYPTED_VALUE
----------------
ENCRYPTED_VALUE
141512473510550932344765206967565539602658354120603344918
Direct Call to ing_d_nvc_cl_fdb420
SELECT dbo.ing_d_nvc_cl_fdb420
('141512473510550932344765206967565539602658354120603344918', /* inputData */
'yourMetaDatabaseName', /* metadb */
'yourKey', /* keyName */
'FPE/CARD10', /* algorithm/cardinality used */
'SHA1:12', /* Padding used */
0x040103000304060409030103070502050503050704010808010202070402070201030407040009
0105020603000002020906070004010200) /* iv */
AS DECRYPTED_VALUE
----------------
DECRYPTED_VALUE
112236276342649837947333444444444555555555555555555555564
Direct Call to dbo.ing_e_vrc_fcl
SELECT dbo.ing_e_vrc_fcl
('asdf1234!@#$1234', /* inputData */
'yourKey', /* keyName */
'FPE/CARD10', /* algorithm/cardinality used */
'SHA256:LAST_FOUR', /* Padding used. Padding should be in
TweakAlgo:TweakData/FpeEncFormat */
0x040103000304060409030103070502050503050704010808010202070402070201030407040009
0105020603000002020906070004010200) /* iv */
AS ENCRYPTED_VALUE
----------------
ENCRYPTED_VALUE
asdf3692!@#$1234
Direct Call to dbo.ing_d_vrc_fcl
SELECT dbo.ing_d_vrc_fcl
('asdf3692!@#$1234', /* inputData */
'yourKey', /* keyName */
'FPE/CARD10', /* algorithm/cardinality used */
'SHA256:LAST_FOUR', /* Padding used. Padding should be in
TweakAlgo:TweakData/FpeEncFormat */
0x040103000304060409030103070502050503050704010808010202070402070201030407040009
0105020603000002020906070004010200) /* iv */
AS DECRYPTED_VALUE
----------------
DECRYPTED_VALUE
asdf1234!@#$1234
Direct Call to dbo.ing_e_chr_fnm
SELECT dbo.ing_e_chr_fnm
('yourCharValue', /* inputData */
'yourDatabase', /* DBName */
'dbo' , /* DBOwnerName */
'yourTable' , /* tableName */
'yourColumn', /* columnName */
0x24A40F6DFB05F379630AC0533E7F6357)
As ENCRYPTED_VALUE
------------------
ENCRYPTED_VALUE
asdf8079!@#$1234
Direct Call to dbo.ing_d_chr_fnm
('asdf8079!@#$1234', /* inputData */
'yourDatabase', /* DBName */
'dbo' , /* DBOwnerName */
'yourTable' , /* tableName */
'yourColumn', /* columnName */
0x24A40F6DFB05F379630AC0533E7F6357) As DECRYPTED_VALUE
-------------------------------------------------------
DECRYPTED_VALUE
asdf3692!@#$1234
