Encrypt Sensitive HR-Payroll Data in Dynamics GP

(0) Share

Report

Posted on by Christopher Rannow

125

Our company is required to adhere to the rules and regulations outlined by the Payment Card Industry Data Security Standards (PCI/DSS). We need to have the ability to encrypt personally identifiable information such as one's Social Security Number within the Dynamics GP database. Does Dynamics GP support encryption of data in certain fields? I understand that we can use SQL to encrypt the entire database but that doesn't help when administrators who have rights to view the contents of the database in general have the ability to select all on a given table and see this data. The data ought to be encrypted within the table itself AND only visible in an unencrypted form on the computers or logins of authorized persons. Has any 3rd party or Microsoft written something to accomplish this task? If not that is very sad.

*This post is locked for comments

All responses (4)

Answers (0)

Laurie Michlig 5 on at

Like (0)

Report

RE: Encrypt Sensitive HR-Payroll Data in Dynamics GP

Hello Christopher,

Our company is under the same security regulations. We also have Nodus eSSS add on and all our customer credit card information is encrypted, however that doesn't resolve the Employee SS# field. How did you ever resolve this issue? Thank you.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Encrypt Sensitive HR-Payroll Data in Dynamics GP

Data protection is terrible at many vendors. Encrypting data at rest does not protect anything from a DBA,or a read only user.
L Vail 65,271 on at

Like (0)

Report

Re: Encrypt Sensitive HR-Payroll Data in Dynamics GP

Have you looked at the solution from Nodus?
Christopher Rannow 125 on at

Like (0)

Report

Re: Encrypt Sensitive HR-Payroll Data in Dynamics GP

I added this as a suggestion for development because it doesn't seem possible currently.

connect.microsoft.com/.../encrypt-sensitive-data-in-dynamics-gp