Bruno, Thanks for the info. In the mean time, I am going with simple and (functional?) the specific fields that need to be protected are encrypted.
While I do need to unencrypt the data for various uses, once encrypted in the database the field is never again un encrypted. When it is needed, it is copied, into a variable, un encrypted, used and thrown away. Chip On Thu, 18 Apr 2019 08:01:17 +0000, Bruno LEGAY via 4D_Tech wrote: > Hi, > > Native database level encryption is coming !!! > > If you need this, it is probably worth waiting for 4D v17 R5 / v18 ! > I would be silly to re-invent the wheel... > > This is a great feature and a good selling point. Thanks 4D. > > https://blog.4d.com/introduction-to-data-encryption-in-4d/ > > Bruno LEGAY > A&C Consulting > > >> Le 2 avr. 2019 à 11:14, Bruno LEGAY <[email protected]> a écrit : >> >> Hi, >> >> Instead of keychain, which is a good idea but maybe problematic for >> cross platform and backing-up / restoring. Don't get me wrong, I >> like and I trust apple iCloud backups but maybe not a good option >> for your situation. >> >> There is the PKCS12 file format which is made to store private keys >> (a keystore)... The file is a secure (encrypted) key store which can >> be opened with a password. >> >> This way, each user has a keystore password (random generated) and a >> pkcs12 file in a blob, the keystone password is encrypted with a >> master password (or using a custom user password). >> The keystore contains the private key. The public key can always be >> generated from a private key. >> You will have to be sure that the system works when user changes his >> main password, etc.. >> >> openssl can manage PKCS12. >> >> Contact me if you need some help on this (I have done a lot of >> openssl stuff with 4D components). >> >> HTH >> Bruno LEGAY >> A&C Consulting >> >> >> > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** --------------- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
