Security and Concurrent use of local database

Hello

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 ?

Thanks

Catherine

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.

Petr

Thanks

Catherine

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.

Tim