cancel
Showing results for 
Search instead for 
Did you mean: 

Column level encryption in SAP HANA

nithinu
Participant
0 Kudos

Hello Experts,

Is there a way I can encrypt a column in a table like what in MS SQL ? When I searched for the answers for this in SCN, I can find an answer that till SPS05 column level encryption is not implemented, but there may be chances for this feature in newer versions. Please guide me on this.

Thanks in advance!

Regards,

Nithin

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member226419
Contributor
0 Kudos

What exactly you want to do in encryption? Can you please explain your requirement?

nithinu
Participant
0 Kudos

Hi Sumeet,

I want to store the passwords of the application users in encrypted format. Hope this clarifies.

Regards,

Nithin

former_member185132
Active Contributor
0 Kudos

You could use the HASH function: https://help.sap.com/saphelp_hanaplatform/helpdata/en/d2/2ecca9d2951014850492e8c88d498c/content.htm

However, it would be good to use a Salt in addition to the actual password itself. So as an input to the HASH function, you provide the password and the salt. How to choose a salt is a matter for experts, suggest you read on that a bit more.

nithinu
Participant
0 Kudos

Thanks for your time Suahs. I just have implemented the password storage policy with HASH function and with some Salt logic as well.