https://community.sap.com/t5/technology-q-a/randomizing-sensitive-data-fields-in-hana-tables/qaa-p/12804859#M4808113 <P>Hi <SPAN class="mention-scrubbed">sreepriyag</SPAN>,</P><P>RAND you can do directly for numbers.</P><P>For dates you can user RAND together with ADD_DATE</P><P>For NVARCHAR you can concatenate with RAND converted to string and function HASH_256</P><P>The important point here is to see the results and check if someone can't reverse to the original number, sometimes just put *** is ok too.</P><P>Regards, Fernando Da Rós</P> Fri, 18 Aug 2023 12:09:27 GMT fedaros 2023-08-18T12:09:27Z https://community.sap.com/t5/technology-q-a/randomizing-sensitive-data-fields-in-hana-tables/qaq-p/12804858 <P>I have a scenario where the data has to be randomized before hitting the DB tables for sensitive data fields like SSN, Salary ,AccountInfo as well as User details .Can I use the RAND () functionto do this ? Is it possible to do RAND on Date, NVARCHAR and string fields? If so, can someone help me here with syntax? Thank you.</P> Wed, 16 Aug 2023 19:01:00 GMT https://community.sap.com/t5/technology-q-a/randomizing-sensitive-data-fields-in-hana-tables/qaq-p/12804858 sreepriyag 2023-08-16T19:01:00Z https://community.sap.com/t5/technology-q-a/randomizing-sensitive-data-fields-in-hana-tables/qaa-p/12804859#M4808113 <P>Hi <SPAN class="mention-scrubbed">sreepriyag</SPAN>,</P><P>RAND you can do directly for numbers.</P><P>For dates you can user RAND together with ADD_DATE</P><P>For NVARCHAR you can concatenate with RAND converted to string and function HASH_256</P><P>The important point here is to see the results and check if someone can't reverse to the original number, sometimes just put *** is ok too.</P><P>Regards, Fernando Da Rós</P> Fri, 18 Aug 2023 12:09:27 GMT https://community.sap.com/t5/technology-q-a/randomizing-sensitive-data-fields-in-hana-tables/qaa-p/12804859#M4808113 fedaros 2023-08-18T12:09:27Z