Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Jo deRuiter]

Hi All:

I cannot locate any reliable documentation on securing data such as SSN’s or EIN’s in GP.

Can someone point me to out-of-the-box information AND any reliable 3rd parties?

Thanks!!!!!

——————————
Jo deRuiter
Lead Techno Functional Consultant
Aisling Dynamics Consulting
Kennesaw GA
——————————

[Steve Endow]

Hi Jo,

I’m not aware of any native functionality in GP that secures, obscures, or encrypts field data (CC numbers, SSNs, etc.).

The only peripherally related option I’ve seen discussed is SQL Server Transparent Data Encryption, but that feature is only available in SQL Server 2008 and 2012 Enterprise Edition, not in Standard edition, so I suspect that rules it out as an option for most GP customers.

I’m interested to hear if there are any third party products that help to protect sensitive fields.

——————————
Steve Endow, Microsoft MVP
Precipio Services
Los Angeles, CA
——————————
——————————————-

[Carol Kossoris]

What do you mean by securing data?  GP does have report masking for the SS numbers in Payroll.  Go to SSN Mask in the payroll setup.  Field level security might also be an option.

——————————
Carol Kossoris
GP Consultant
Heartland Business Systems, LLC
Pewaukee WI
——————————
——————————————-

[David Musgrave]

It is possible to use GP Power Tools non-logging triggers to “Obscure” data in the SQL Server.

I have to say Obscure because when I first used the term “encrypt”, I got into trouble as example I gave does not use industry standard encryption.

Have a look at

https://blogs.msdn.microsoft.com/developingfordynamicsgp/2012/10/09/further-update-obscuring-table-data-fields-using-the-support-debugging-tool/

https://blogs.msdn.microsoft.com/developingfordynamicsgp/2012/07/31/obscuring-table-data-fields-using-the-support-debugging-tool/

https://blogs.msdn.microsoft.com/developingfordynamicsgp/2012/08/19/update-obscuring-table-data-fields-using-the-support-debugging-tool/

Please note that the Support Debugging Tool was discontinued and replaced by GP Power Tools.

GP Power Tools portal: http://WinthropDC.com/GPPT

David

——————————
David Musgrave MVP, GPUG All-Star

Managing Director
Winthrop Development Consultants

Perth, Western Australia

http://www.winthropdc.com
——————————
——————————————-