Subject | Changing SYSDBA password |
---|---|
Author | Tony Christiansen |
Post date | 2018-09-11T08:09:20Z |
I am using FB 3.0 and had the SYSPDA pw as masterkey.
I changed it per the notes as I understood ie opened a database and ran
this query
alter user sysdba set password 'newpassword'
It committed ok with no errors but I can still open databases using
SYSDBA and masterkey as the password. I expected when I changed the
password I would not be able to open any databases with the old password.
I tried restarting the FB server but no change.
Am I missing a step?
Thanks
Tony
I changed it per the notes as I understood ie opened a database and ran
this query
alter user sysdba set password 'newpassword'
It committed ok with no errors but I can still open databases using
SYSDBA and masterkey as the password. I expected when I changed the
password I would not be able to open any databases with the old password.
I tried restarting the FB server but no change.
Am I missing a step?
Thanks
Tony