on 06-19-2017 8:00 PM
Hi Lars,
Can we implement HANA column level data encryption and decryption (by role) / HANA SQL?
Below is what I am trying to design: please review and advise. Thanks.
–Need the functionality to encrypt column level data in SLT during read/write operation and store encrypted value in HANA table column, decrypt data using HANA security roles for SAP ECC ( ISU and CRM) Data –
–Need the functionality to encrypt column level data within HANA during data transformation ( table to table ) and decrypt data back using HANA security roles for any HANA table.column
SAP HANA doesn't provide a functionality for column level encryption as of now (HANA2 SPS1).
What is available is a *column masking* option in the modelling environment.
Also, there had been modelling approaches to implement data access based on roles/privileges (you should find those, if you look around here on SCN).
Bottom line on that is: you will have to implement the data access/masking/scrambling scheme yourself in the system. There is no simple function, that would lock/unlock access to certain columns by role membership.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
75 | |
10 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.