On 2020-05-28 11:22, Alex Peshkoff via Firebird-devel wrote:
On 2020-05-28 12:06, Dimitry Sibiryakov wrote:
28.05.2020 00:35, Adriano dos Santos Fernandes wrote:
It's more confusing to have a "functional" security database without
users
No SRP users doesn't also mean no legacy or SSPI users.
Certainly, but in this case the best solution is to remove SRP plugin
from configuration.
Possibility to work without SYSDBA account is a feature not bug.
Definitely.
But - users who know how (and what for) to use such specific ways of
managing security on firebird server almost for sure also know what to
do in a case when SRP data structures were not initalized. We talk
about a message which should be as clear as possible for novice.
And that is covered by the normal error message:
"""
Your user name and password are not defined. Ask your database
administrator to set up a Firebird login.
"""
If the instruction "Ask your database administrator to set up a Firebird
login." is followed, then the problem resolves itself, just like it
would if the security database was initialized, but the user simply
didn't exist (or had the wrong password). This is more clear than the
instruction to look at the compatibility chapter, which - IIRC - was
initially not even very clear on what needed to happen to solve the
problem.
Alternatively, this error (isc_login) should be reported as the main
error, with a secondary error with additional information.
Mark
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
