Subject AW: [firebird-support] user manager?
Author Check_Mail

..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 <firebird-support@yahoogroups.com>
Gesendet: Freitag, 12. April 2019 11:15
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] user manager?

12.04.2019 7:27, 'Check_Mail' check_mail@... [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