Subject RE: [firebird-support] Query regarding Firebird Login
Author Helen Borrie
At 10:28 PM 1/02/2007, you wrote:
>Hi Helen,
>The following are the environment details.
>OS: Windows XP
>Language: Java(j2sdk 5.0)
>MappingTool: Ibatis.
>ServerName: Super Server

Assuming you have the standard Firebird root filesystem:
cd c:\Windows\Firebird\Firebird_1_5\bin

To remove a user named ordinary (it is case-insensitive):
gsec -delete ordinary -user sysdba -password brwbzqrh

To add a new user (passwords are case-sensitive):
gsec -add newbie -pw toffee3 -user sysdba -password brwbzqrh

To change a user's password:
gsec -modify newbie -pw sherbet5 -user sysdba -password brwbzqrh

To change the sysdba password
gsec -modify sysdba -pw reborn83 -user sysdba -password brwbzqrh

To change a password using a remote instance of gsec (all in one command):

gsec -database "myhost:c:\Program Files\Firebird\Firebird_1_5\security.fdb"
-modify newbie -pw sherbet5 -user sysdba -password brwbzqrh

There's more. You can also run gsec as a shell application by
starting it from the command-line in the ..\bin directory:

gsec -user sysdba -password reborn83
Further instructions, read the IB 6.0 Operations Guide (or Chapter 34
of The Firebird Book)