New topic: Database protection options.Need help
<http://forums.realsoftware.com/viewtopic.php?t=46264> Page 1 of 1 [ 6 posts ] Previous topic | Next topic Author Message Antonio Post subject: Database protection options.Need helpPosted: Mon Dec 17, 2012 10:18 am Joined: Sat Feb 04, 2012 1:26 pm Posts: 48 Hi, I am trying to understand better about db protection. As i feel a little bit confused i need some help. 1) I wonder if the are some dbms safer than others? 2) As for the protection of the data, I saw there is the db.encrypt and db.encryptionkey. If I decrypt the database as the program is launched and encrypt it again before the programs close, will the data be readable from outside during the time the program has not been closed yet? 3) I also tought about writing the records after having some way encrypted the plain text, so that someone opens the db file, records are not easy readable. Does it offer a good protection? 4) is hashing another way to protect databases? 5) password protected file and encrypted file is the same thing? I refer to the possibility the user has with ms access to protect the mdb file with a password from inside the ms access itself. Thanks for any help. Top DaveS Post subject: Re: Database protection options.Need helpPosted: Mon Dec 17, 2012 11:04 am Joined: Sun Aug 05, 2007 10:46 am Posts: 4335 Location: San Diego, CA 1) yes..... commerical ones will usually be "safer" than "free" ones. 2) normally in this situation, the database is encrypted the entire time... and the app encrypts/decrypts the data on each read/write 3) not a good idea.... go with #2 4) "hashing" is one method used by #2 5) depends.. is this a local database? LAN based? or remote? are you looking to protect it from "prying eyes"... or possible "data thiefs" _________________ Dave Sisemore MacPro, OSX Lion 10.7.4 RB2012r1 Note : I am not interested in any solutions that involve custom Plug-ins of any kind Top Antonio Post subject: Re: Database protection options.Need helpPosted: Mon Dec 17, 2012 11:55 am Joined: Sat Feb 04, 2012 1:26 pm Posts: 48 Hi Dave, the DB will be located just on a PC. Maybe in the future might be on a shared hd. In the case of a shared access, main concern might be more about prying eyes than data theft, as they are not that valuable data. Anyway, as you mention different ways of DB accessing by local, remote, or Lan, which are the differences the db should have in those cases ? Top timhare Post subject: Re: Database protection options.Need helpPosted: Mon Dec 17, 2012 12:10 pm Joined: Fri Jan 06, 2006 3:21 pm Posts: 11894 Location: Portland, OR USA Encrypt/Decrypt/EncryptionKey apply to REALSQLdatabase only. You Encrypt the database upon creation and thereafter you supply the EncryptionKey when you open it. The database remains encrypted on disk and the information is encrypted/decrypted as you read and write to it. You use Decrypt when you change your mind and want to un-encrypt the database. Hash <> Encryption. Hashing is one-way; it cannot be reversed. Some information, such as passwords, should be stored as a hash. For a database stored locally, you can use REALSQLdatabase. Otherwise, use a database server. Some database servers allow a secure connection. Otherwise, the data is sent across the network in plain text. But that is just fine if your concern is casual "prying eyes". Top Antonio Post subject: Re: Database protection options.Need helpPosted: Mon Dec 17, 2012 4:59 pm Joined: Sat Feb 04, 2012 1:26 pm Posts: 48 Thanks for the help, Dave, Tim. I am learning more and more with your help. Returning to the topic, once I have encrypted a db, it should not be possible to open that file with a db management software. Isn't it? Top timhare Post subject: Re: Database protection options.Need helpPosted: Mon Dec 17, 2012 5:15 pm Joined: Fri Jan 06, 2006 3:21 pm Posts: 11894 Location: Portland, OR USA Quote:once I have encrypted a db, it should not be possible to open that file with a db management software. Isn't it? Not without supplying the encryption key. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 6 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
