Using Encryption in BO XI

[kambike]

HI,

We have some sensitive data for the company. If this data is in encrypted format in database, can BO read and decrypt ot to display?

In general how can BO use encryption? Is there any way in BO to handle encryption, specially if we do not want to allow anyone to see the sensitive data diretly.

Regards
Kambike

 

[mixsuresh]

As far as my knowledge goes, I don't think there is any encryption or decryption BO automatically does.

If you have encrypted data in the database, you probably know the encryption logic, you have to write a query or program to decrypt it.

However if you don't want users to see sensitive data, one solution is to mask some character(s) in the data by replacing it with some character "X".

 

[skrandel]

If you want the sensitive data to be visible to only the users who use BO, then you need to use a stored function in the select portion of the object.

eg. decrypt_me(table.column)


Steve Krandel
Intuit

 

[kambike]

What we want in the project is that the data in the database should be encrypted so that no one can access it directly. This data should be decrypted in BO when the user is running a report and shown to him. Can we do it in BO? Is there any way where I can call any external DLL / program to decrypt?

Regards,
kambike

 

[skrandel]

It is possible, but only in the BO client. I don't know how to do it. You should check on

http://busobj.forumtopics.com

Steve Krandel
Intuit