Subject | RE: [firebird-support] Query regarding Firebird Login |
---|---|
Author | rambabu.piridi@wipro.com |
Post date | 2007-02-01T13:24:15Z |
Thank you Helen,
Regards,
Rambabu
________________________________
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Helen Borrie
Sent: Thursday, February 01, 2007 6:34 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Query regarding Firebird Login
At 10:28 PM 1/02/2007, you wrote:
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
of The Firebird Book)
./heLen
./helen
[Non-text portions of this message have been removed]
Regards,
Rambabu
________________________________
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Helen Borrie
Sent: Thursday, February 01, 2007 6:34 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Query regarding Firebird Login
At 10:28 PM 1/02/2007, you wrote:
>Hi Helen,Assuming you have the standard Firebird root filesystem:
>
>The following are the environment details.
>
>OS: Windows XP
>Language: Java(j2sdk 5.0)
>Firebird:1.5.2
>MappingTool: Ibatis.
>ServerName: Super Server
>
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
>GSECFurther instructions, read the IB 6.0 Operations Guide (or Chapter 34
of The Firebird Book)
./heLen
./helen
[Non-text portions of this message have been removed]