14,855
Dear
I have sensitive data like the credit card number which I want to protect from regular users, and i want only one user or group of users to be able to see this information.
how do you suggest i do it ? is there anyway to ********** hash a number in AX
what is the best way to go at it ?
Regards
*This post is locked for comments
This kind of error occurs when the size of the string/key it's bigger than the size of the field. Verify the EDT or StringSize of the field.
In your case, try use the EDT CrytoBlob - Type container.
I Hope this Helps!
Regards,
Rodolfo Recalde.
Hi Rudolfo,
I created a simple table with username and password fields using string for username and container with edt cryptoblob. I have used the same code as sysemailparameters form. when i entered the data and closed the form it gives the below error.
SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated.
not sure why this is coming as my data goes into a container.
Please help me with this.
Thanks
Hi Patrick,
Maybe you can use Type Field Container with ExtendedDataType CryptoBlob in your table.
see the example in the SysEmailParameters form. method edit setPassword (AX 2012 R3).
You can return the encrypted value through this call, according to his user group rule:
cryptoblob2str(WinapiServer::cryptUnprotectData([YourTable].[YourFieldContainerCryptoBlobPassword]));
Be very careful with credit card number and other confidential information. (usually is not a good idea to store the number of credit card in your system....I have witnessed a lot of trouble with that).
http://stackoverflow.com/questions/3328922/saving-credit-card-information-in-mysql-database
See also this example:
I Hope this Helps!
Regards,
Rodolfo Recalde.
#1
Kempeth
4
#1
Andy Adamak
4
#1
Community Member
4
Share
Report
All responses (
Answers (
