I am using Libreoffice base 6.3.6.2 (x64) on Windows 10 with a newly splitted HSQLDB database.
Thinking of the possibility of having the database on a dropbox to make it accessible anywhere.
Is there a way to create a password to protect the database? I know that this should actually be done when opening the database for the first time but I missed this, reading the HyperSQL manual doesn’t make things clear to me as a newbie.
Any information would be welcome.
Hello,
In order to “protect” a database with passwords you need to create users with privileges and passwords. Then when trying to access data through a Base file, that user must sign on (log in) first. Then based on the authority given, different tasks can be done. For example not all users should be able to create or delete tables.
The HSQLDB manual does have this information. It is creating users and is done through SQL.
The only other item which may be password protected is macro code. This is done in the library and information is in the documentation.
Also be cautious with using cloud services and Base. First, wherever used, LO must be correctly installed. Second, do NOT use it within the synced directory. Always have a backup somewhere other than the cloud. Have seen enough problems with lost Base data using cloud services.
Thank you @ratslinger, this helps me much. So do I understand that it might better keeping it local with a daily backup? single user here
Basically care is needed. It is OK to store the entire folder anywhere. Where you may have problems is retrieving the folder & using that. The problems I have seen & experienced dealt with using Base in the synced folder.
There is no way I can say what is better as each of us has a different need and purpose for what we do. I just want you to be aware of possible situations.