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)
>Firebird:1.5.2
>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
DON'T DELETE THE SYSDBA USER!!!

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

>GSEC

Further instructions, read the IB 6.0 Operations Guide (or Chapter 34
of The Firebird Book)

./heLen


./helen