Subject | How do you change the SYSDBA Password |
---|---|
Author | dkoder2 |
Post date | 2007-03-13T21:03:18Z |
I swear I am about ready to go back to stone tablets and a chisel. I
finally gave up on getting the embedded database to work and now I
having trouble changing the SYSDBA password. I have searched the docs,
the net, and this forum and not one of the examples seem to work.
My programming environment:
W2K (SP4).
Visual Basic 6.0 (SP6)
Firebird 2.0
Firebird Registry Entry
DefaultInstance: C:\Program Files\Firebird_2_0\
Database Type: Client\Super
Most successful attempts:
C:\Program Files\Firebird\bin\>gsec -database "localhost:C:\Program
Files\Firebird_2_0\Security2.fdb -modify sysdba -pw masterkey -user
sysdba -pw abcdefgh
WARNING - maximum 8 significant bytes of password used
password already specified
C:\Program Files\Firebird\bin\>gsec -database "localhost:C:\Program
Files\Firebird_2_0\Security2.fdb" -modify sysdba -pw masterkey -user
sysdba -pw abcdefgh
The command to change the SYSDBA password and the results:
C:\>gsec -modify sysdba -pass masterkey -user sysdba -pass abcdefgh
database administrator password already specified
C:\>gsec -display -user SYSDBA -pass masterkey
Show list of user as expected but proves password has not been changed
I have tried every iteration conceivable using -d, database, -pw,
-pass, -password, etc. and still cannot modify the SYSDBA password. I
single quoted, double quoted and no quotes. I don't have a clue about
what to do next.
TIA dkoder2
finally gave up on getting the embedded database to work and now I
having trouble changing the SYSDBA password. I have searched the docs,
the net, and this forum and not one of the examples seem to work.
My programming environment:
W2K (SP4).
Visual Basic 6.0 (SP6)
Firebird 2.0
Firebird Registry Entry
DefaultInstance: C:\Program Files\Firebird_2_0\
Database Type: Client\Super
Most successful attempts:
C:\Program Files\Firebird\bin\>gsec -database "localhost:C:\Program
Files\Firebird_2_0\Security2.fdb -modify sysdba -pw masterkey -user
sysdba -pw abcdefgh
WARNING - maximum 8 significant bytes of password used
password already specified
C:\Program Files\Firebird\bin\>gsec -database "localhost:C:\Program
Files\Firebird_2_0\Security2.fdb" -modify sysdba -pw masterkey -user
sysdba -pw abcdefgh
The command to change the SYSDBA password and the results:
C:\>gsec -modify sysdba -pass masterkey -user sysdba -pass abcdefgh
database administrator password already specified
C:\>gsec -display -user SYSDBA -pass masterkey
Show list of user as expected but proves password has not been changed
I have tried every iteration conceivable using -d, database, -pw,
-pass, -password, etc. and still cannot modify the SYSDBA password. I
single quoted, double quoted and no quotes. I don't have a clue about
what to do next.
TIA dkoder2