And that passwords must be delivered to users. Existing upgrade process creates random passwords for all users. One job for your sysadmin - after upgrade of security database 'legacy => srp' legacy passwords are lost (list of users remains). Jaybird), then the new authentication method should be entirely transparent to you and not require work for your developers. If you install Firebird with the default setting (that is, it uses the new authentication options), and assuming you either use fbclient of Firebird 3 and higher, or a connection library that supports the new authentication (e.g. Our developers probably didn't have the time to adjust the system to the new authentication method. On 4/27/22 17:40, Mark Rotteveel wrote: I meant 'Firebird supports that'. Can you confirm that a linux install is showing That would rule this outĪs a Windows installer bug. You also mentioned that you confirmed this on linux. So, theoretically at least, the provided password should be set.īut yes, you seem to be correct - users can log in with masterkey. SYSDBA Sql Server Administrator Legacy_UserManager USER_NAME FULL USER NAME SEC$ACTIVE SEC$ADMIN SEC$PLUGIN GetAdminUserPassword + ''' using plugin Legacy_UserManager 'Īnd I end up with these two lines in sec$users: 'create or alter user ' + GetAdminUserName + ' password ''' + If EnableLegac圜lientAuth is checked then this line is also executed: 'create user ' + GetAdminUserName + ' password ''' + GetAdminUserPassword +Īnd the SEC$USERS shows a single entry for SYSDBA. This is what the installer executes if EnableLegac圜lientAuth is NOT

Ibexpert forgot password