--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > Hi all!
> >
> > I have four requests: (sorry if post to wrong place)
> >
> > 1.Add a function to retrieve current GMT/UTC time.
> >
> > 2.Remove the need of "SET TERM" - It's really boring. Interbase 7

has

> > done this, right?
> >
> > 3.Make isql to print the correct line number(s) when there is
> > something wrong in the input file (.sql)
> >
> > 4.I have worked out the method to use non-admin login for

firebird on

> > windows nt, where can I post it?
> >
> >
> > Thank you!
>
> for number 4 - post it here

1.Download and Install.

2.Run lusrmgr.msc, create a new user called "Firebird", give it a
safe password.

3.Run secpol.msc, go to Security Settings\Local Policies\User Rights
Assignment, add "Firebird" in the policy "Logon as a service"

4.Run services.msc, choose "Firebird Server ...", right-click ->
property, logon tab, and change the user from System to "Firebird",
then set the password.

5.Choose a data directory to put config files, lock file, UDFs and
databases (if you want), give the user "Firebird" full permission to
access it.

6.Copy security.fdb, aliases.conf, and firebird.conf from firebird
installation path to the data directory you just choosed.

7.In services.msc, start "Secondary Logon" if it's not started yet.

8.In command-line, execute "runas /user:firebird regedit.exe", then
go to HKEY_CURRENT_USER\Environment, add two string values: FIREBIRD
and FIREBIRD_MSG -- FIREBIRD is set to the data directory
(ex: "D:\firebird"), and FIREBIRD_MSG is set to the firebird
installation directory, where the file "firebird.msg" is located.

9.Edit <DATA_DIRECTORY>\aliases.conf, add the following line:
security = <DATA_DIRECTORY>\security.fdb
And later after starting the firebird server, you may configure user
permissions by executing: gsec -user sysdba -password masterkey -
database "127.0.0.1:security"

10.Now Everything Is Done! Start the server by "net start
FirebirdServerDefaultInstance"!

11.Keep in mind that when you create a new database or connect to an
existing one without using alias and absolute path, firebird uses
C:\WINDOWS\system32 as its parent directory, *** AND FIREBIRD DOESN'T
HAVE THE PERMISSION TO WRITE OR CREATE ANYTHING UNDER IT BY DEFAULT
***

12.If you install new versions of firebird, just repeat Step #4, and
Step #7 & #8 to change the environment variable FIREBIRD_MSG if the
new installation directory is different.


Cheers!