We would use the embedded database, however our application connects to two databases simultaneously: one is remote, one is local...

"be warned that a user can *always* get full access if he wants to, if he has the physical db file."
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?

--- In firebird-support@yahoogroups.com, Paul Vinkenoog <paul@...> wrote:
>
> Hi blizzard,
>
> > Can I just deploy the security2.fdb file?
>
> Yes, that's possible, as long as you don't copy it to the target
> machine while the server is already running there.
>
> But you can also consider using the Firebird Embedded Server, if the
> database you distribute does not contain anything you want to hide
> from the user. (And if it does, be warned that a user can *always* get
> full access if he wants to, if he has the physical db file.)
>
> The Firebird Embedded Server is packed (and unpacked) with your
> application and the database, and there is no server installation
> process (and no conflict with a possible already present server!)
> See http://www.firebirdsql.org/manual/ufb-cs-embedded.html
>
>
> Greetings,
> Paul Vinkenoog
>