Symmetrically encryption of data inISM database: a number of constraints have been found - I was wondering if anyone on the community has in-depth experience of encryption of fields perhaps. Logged a support call and had a look in the community and helpfile but no answers forthcoming.
Unable to search on an encrypted field.
Unable to do a full text search on an encrypted field.
It is possible to set an encrypted field as sortable in a list, but the sort is done by the encrypted value and not the unencrypted value.
It is possible to filter on an an encrypted field in a list, but the filter is done by the encrypted value and not the unencrypted value.
Questions: SQL Report from outside of ISM- is it possible to decrypt fields in reports? I know you can use encryption keys in each query.
DECLARE @Result varbinary(256) SET @Result = EncryptByKey(Key_GUID('MySymmetricKeyName'), @ValueToEncrypt)Decrypting Data : You can decrypt data by using the DecryptByKey function, like so:
DECLARE @Result varchar(max) SET @Result = DecryptByKey(@ValueToDecrypt)
Can encryption be done via database stored procedures, which perform the encryption and decryption. Can ISM then interfaces with these stored procedures and write/read data to the DB?