How to change SYSDBA password automatically on installation?

I have a windows application using Firebird 1.5 and I need to automate the install procedure more.

How can I automatically set the SYSDBA password to what I need after installing Firebird?

I also need to create 2 users on the srever and grant them read/write/execute premission ot all tables and procedures in my database file.

What is the best way to automate this as part of the end user installation?

Why not distribute the security.fdb with all the settings (if the client does not already have another Firebird app installed).

Tell your install program to execute following AFTER firebird is installed and is running:

Change to the directory where the command-line tools for the Firebird Database Server are located. (On Windows this will be c:\Program Files\Firebird\Firebird_1_5\bin. On Linux this directory is /opt/firebird/bin)
Execute the following (case-sensitive):
gsec -user sysdba -password masterkey

It will start shell prompt for the gsec utility: (you have to send programatically command to this utility, cannot remember correct way right now, investigate a little)

Enter the following command to change the password:
GSEC> modify sysdba -pw newpassword
Where newpassword is the 6-8 character new password you chose.


That's it.


--
Best regards,
Fikret Hasovic http://fikret.fbtalk.net

FirebirdSQL Foundation member.
- Join today at http://www.firebirdsql.org/ff/foundation
JEDI VCS contributor
http://jedivcs.sourceforge.net/

This sounds like a good idea
How do I determine the path to this file on the clients system?

I am dealing with Firebird on Windows98 and above. There must be some way to detect the Firebird root installation directory. Is there something in the registry I can use? Is there some way I can look at the running server and work it out?
Please help me out with some suggestions, I am stuck

I have FireBird 1.5 installed and this is where the root directory is stored to my registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Firebird Project\Firebird Server\Instances >> DefaultInstance

I have checked this on all the machines I have runnung and it looks like a good place to find the firebird root path. Thankyou everyone for helping me