I’m not really in a problem solving, but while testing LO Base possibilities, was wondering what are exactly the differences between the Firebird options.
As I understand, there are 3 options to work with Firebird in LO Base:
- embedded: this is what I know, and for which I did not get problem, although my experience with LO Base is still poor)
- connection to an existing database - option Firebird File: this is I understand to be the one with SDBC connection embedded in LO Base
- connection to an existing database - other connection: as I understand from other posts on this forum, the JDBC is the one doing well for Firebird; and this solution thus bases on an external Firebird file and server (server on the same machine or remote machine?).
My questions are mainly on the option 2 (SDBC Firebird File connection). Indeed, what is the advantage over the option 3?
I guess that there is the possibility to create one without having a standalone Firebird installation. But is this file easily accessible by a standalone Firebird installation is needed later or when sharing to someone else (on a different machine, even without LibreOffice)?
And how to deal with users and their rights? (eg. how to know the admin password for example)
Is it possible to work with that in multi-user?
By quickly trying, I could indeed create a Firebird File alongside an ODB file, and create tables, but when selecting ‘Tools’ > ’ User Administration…’, I see that two users are here: SYSDBA and PUBLIC. I can delete one, but create one doesn’t do anything, and I can not tick any of the fields (Read data, Insert data, etc.).
And so, briefly, for which use this configuration may be preferred to the other ones?
Thank you very much for any feedback!