...if I use the fbclient.dll, I can connect with every password, why?
Von: firebird-support@yahoogroups.com <firebird-support@yahoogroups.com> Gesendet: Freitag, 12. April 2019 12:06 An: firebird-support@yahoogroups.com Betreff: AW: [firebird-support] user manager? Hello Dimitry, now, I have installed firebird completely fresh, all settings are standard, srp is only active (Usermanager, firebird.conf). ALTER USER SYSDBA password 'Passw' using plugin srp works, but I can still connect with the "masterkey" password. With " select * from sec$users" I get only the srp-sysdba-user. Some of my databases show me users, some not. (ibexpert). Does the standard value have to be changed for client_auth-settings? How can I denied the access with the masterkey password? And should I set it for all databases or for each? Thank you! -----Ursprüngliche Nachricht----- Von: firebird-support@yahoogroups.com <mailto:firebird-support@yahoogroups.com> <firebird-support@yahoogroups.com <mailto:firebird-support@yahoogroups.com> > Gesendet: Freitag, 12. April 2019 11:15 An: firebird-support@yahoogroups.com <mailto:firebird-support@yahoogroups.com> Betreff: Re: [firebird-support] user manager? 12.04.2019 7:27, 'Check_Mail' check_m...@satron.de <mailto:check_m...@satron.de> [firebird-support] wrote: > how can I change both sysdba-passwords? The one from srp and the other from legacy auth? "ALTER USER" clause has "USING" part which set user manager to be used. -- WBR, SD. ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links