Skip to Content
0
Feb 06, 2019 at 01:06 PM

How to Mask or Encrypt a particular column of a table In SAP HANA

278 Views

Hi All,

I have a requirement to Mask a particular columns of a table. I have a table MASK_DATA and i need to mask/encrypt the column "Password" so that no other users can see this column information.

I could not able to achieve this with the below command. any suggestions on how to mask single or multiple columns of a table in HANA ??

ALTER TABLE "TMP_SCHEMA"."MASK_DATA" ADD MASK ("PASSWORD" USING '****');

Thanks
Rufus Samuel