We intend to set up the security on a local database with one editor account and several read-only accounts.
Can we safely have several users searching the data at the same time when the editor is logged on and may be editing data as well ?
If editor doesn't change database structure and schema it will be working fine for multiple editors and readers. Reader can also explicitely reload data by using Data->Reload data action from main menu.
I think this needs clarification. Catherine mentions ue of a local database. Applying security to a local database is fully supported, using just the same approach as a remote database. But concurrent access to a local database is not supported, The Derby database used for the local database only allows access from one Java virtual machine at a time, so multiple users will not be able to access the database at the same time, even if the database is lcoated on a file server where multiple users can see the files at the same time.
Even if only one user accesses the database at the same time this is still not a recomended approach. Using a shared MySQL or Oracle database is the recommended approach.