--- In firebird-support@yahoogroups.com, "seena.mathew"
<seena.mathew@...> wrote:

>
> Hi All ,
>
> I am new to firebird , I have few doubts , 3
>
> 1) what is the difference with firebird running as as server and an
> application . For a windows application which is prefferred.

You can run the database *server* as either a *service* or as an
application. Running the server as a service is preferred, because it
means that you don't need to have anyone logged into the server
console. With 2000 or newer, you can also define recovery options like
restarting the service or sending a message to an administrator, or
tell Windows you need the Firebird service running before it launches
any service applications you write that depend on the Firebird dbms.

Running as an application is really only useful for Win95, 98 or ME,
and only because they do not support the concept of services.

> 2) For apps with firebird should i use the defaul user or some other

Are you talking about the operating system user to install the service
as(default SYSTEM), or are you talking about the database user (who
you are connecting to the database as assuming the server is running)?

From a security standpoint, it is better to change the service to run
as a different operating system user to SYSTEM. Create one called
Firebird, and then use the Windows ACL to only give it the access to
the folders it needs. That way, if a vulnerability is discovered in
Firebird in the future, you have limited the potential implications.

You should use a different database user to SYSDBA to run queries etc.
Using roles, you can grant permissions to particular datbase objects,
and then grant roles to particular database users.

I strongly suggest you read the quick start guide, which you can
download from www.firebirdsql.org in the documentation section.

Adam