Encryption of property values at BLOB level
Hi Everyone - I have Created a class with a unexposed property and in Blob , As per PDN article , if we need to encrypt the blob data , we need to select the checkbox Encrypt BLOB ? on the Rule-Obj-Class definition.
Once this is done and all the Pega encryption utilities are executed successfully and class is in db , and prconfig values set . On the PRPC UI, entered value for this property and saved it in db .
How do I make sure or check if the value for this property in the BLOB is in encrypted format.
After doing a obj-open, Obj-Open-By-Handle and Obj-Browse , the value that displayed on the clipboard for the BLOB are decompressed and decrypted .
I need to check the value for the property in the BLOB in encrypted format. Is there any way to get that?
I have done the encryption/decryption for few exposed properties with type as TextEncrypted, need to check the same at the BLOB level
Danny
Infosys
AU
In your Pega DB there should be a function by name pr_read_from_stream, using this we can read values from blob. I think in your case it should show the encrypted values.
For example if the property name is "myProp" that goes into BLOB then following SQL should work:
Select pr_read_from_stream('myProp', pzInsKey, pzPVStream) from table_name;
Murali...
AMEX
US
Hi Murali - The pr_read_from_stream function can only be used with pc_work , if i use the same function with my work table pc_abc_work it gives an error on the SQL editor.
Select pr_read_from_stream('state', pzInsKey, pzPVStream) from pc_abc_Work ;
ERROR: could not access file "pljava": No such file or directory
Also I need something that i can use in an activity to read and display the value from the Blob in encrypted format on the clipboard , Is that possible ?
Thanks
Danny