Okay I have an idea...

As explained I have a central remote database with my user SYSDBA and password p@ssword.
Then I have my local client database.
My software connects to both databases.
If I could use embedded firebird for the local database, and deploy a security2.fdb file, would that then mean they could not access the local DB without the correct password?
Or could they simply copy the DB file to another PC and access it without a password?

--- In firebird-support@yahoogroups.com, Dimitry Sibiryakov <sd@...> wrote:
>
> > We would use the embedded database, however our application connects to two databases simultaneously: one is remote, one is local...
>
> FB Embeddd works also as a client library.
>
> > This is a problem for me that I did not know. If I create a database file and I set up a username and password, I want to restrict access to only the SYSDBA user with my special password.
> > Isn't that possible?
>
> Yes, that is not possible.
>
> SY, SD.
>