Dear colleagues, is there a way to have user restrictions embedded into the database? I learned user accounts and passwords are stored as part of the DBMS, but not as part of the DB. Therefore someone could copy the physical DB-files to an memorystick, move it to another machine and with a fresh installation of MariaDB he can read and modify all data.
We create a desktop application and would like to distribute a database with private information to the end users. Is there a way we can hide this information and restrict its access only by using our client application but not by any other client?
Sure we could encrypt our secret data, but than the DBMS could not create inizes, constrains, etc.
Thank you in advance. Best regards, Thomas
Env: WinXP, Win7, Win8
Answer Answered by Vladislav Vaintroub in this comment.
Also, there is copious information available on encrypted file system or EFS - you're running on Windows, so you're probably lucky in that you can use FS encryption that comes out-of-the-box.
seems to be related to your question.