We need to develop a TSR style program which will decrypt data stored in MSSQL 2000/2005/2008 database tables.
The TSR will need to check entry passwords against a list of passwords stored in the MSSQL database.
If found, then decrypt the data from a field on screen only.
We need a MSSQL Procedure activated by a SQL Trigger which will take a memo/text field, parse it and ENCRYPT the string and then save the data back to the SQL database. We will provide the trigger and encoding portion of this project. The De-cryptor portion is all that is needed at this time.
i.e. Line X and line Y of a text block would be encrypted with a formula (run length encoding). The program below must decrypt and present data unencrypted to a user on the screen.
When the data is Viewed (later) we will need a TSR (Terminate-Stay-Resident) style program which will be activated by a 2-3 keystroke sequence (i.e. Shift-Ctrl-Z). The TSR will request a user password; the TSR will determine if the password is correct and if correct present data. If the password is not found, then an notification dialog is presented and the program closes in X seconds.
The TSR program must then read an active dialog box from a CRM program which would be onscreen. The dialog read would entail connecting to the CRM system to determine the actual record being presented in order to read the text/memo field to decrypt directly from the MSSQL database.
The result of the TSR would show the UN-encrypted block of information in its own dialog for the user to read. The unencrypted data display would stay on the screen for X secs and never be saved in any other manner.
The user passwords and Run Length encryption string would be stored in a SQL Data table.