maria-discuss team mailing list archive

[AskMonty KB <noreply@xxxxxxxxxxxx>]

Hello,

A new question has been asked in "Getting Started" by TommiG:
--------------------------------
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
--------------------------------

To view or answer this question please visit: http://kb.askmonty.org/en/database-password/