Jonathan Hull wrote:

>Thanks for that Alaxandre.
>
>I guess the Embedded Server is what I am looking for, as all remote
>DB application connections are being routed through a remote and
>local Apache web server (with query + results batching, compression,
>encryption etc), so Apache can be the 'data server' and fbembed.dll
>can service the actual queries that Apache issues.
>
>This has an excellent side effect of requiring no port at all for FB
>(only the Apache port) so Firewall config is halved.
>
>The only issue I have is that of security. Am I right in
>interpreting from the documentation that any username / password can
>be used, and it is the DB permissions that enforce security?
>
>Cheers,
>Jono
>
>

Jono,

1.) Embebed server only a single application to access the database,
don't know how threads apply here, and AFAIR Apache can spawn mutiple
process, so I think this can be an issue (not sure here since I don't
use embebed and don't know Apache very well, I just use the basic
configuration to make internal use).

2.) Yes, in Embebed any user/password are accepted, but you can
grant/revoke privilegies on the data objects (tables, views, stored
procedures, etc.) these will be inforced for the given user.

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br