Do you know how to doubly encipher a database?
Not sure if this should be on the beginners or maybe the database board, but here goes...
I'm learning to use Java by developing a database application and am considering design choices.
The database will be used by several different user connected via JDBC to an existing DBMS (access,paradox, sysbase etc - that choice is still open). I will create the original data in advance The users would query & extract their own subsets of the database, saving to disk for later retreival.
So far , no real problem.
But what if (1) I want to protect the original database and (2) they also want to protect their data? My beginners questions are:
1) How do I add a layer of encryption to the original database?
2) Could a second layer of encryption be set by the user?
[For example department X might have one key shared by the employees in that department, whereas department Y could share a different key].
The encryption level would not have to be particularly 'strong' - just enough to prevent , say , a computer literate 'casual browser'. Also to deny direct access using the original database program , MS-access , paradox etc.
(For info the JDK being used is 1.2.1, the OS is windows 95 and the IDE is Jbuilder 3 professional, that original 'master' database would be perhaps 3,000 records).
Finally, I'm fairly new to Java and a complete novice regarding Java/encryption.
thanks in advance for any help
Mike.
