Subject Re: [firebird-support] Re: How to check and (possibly) repair new authorization system on Firebird 3.0.1
Author Mark Rotteveel
On 2017-03-01 09:59, Dmitry Yemanov dimitr@...
[firebird-support] wrote:
> 01.03.2017 11:58, jonatan.lauritsen@... wrote:
>
>> OK, I have working Firebird 3.0.1 installation and I have copied
>> security3.fdb from the broken Firebird installation and now I am also
>> receiving the error message. So - security3.fdb is somehow broken,
>> problem is in security3.fdb
>
> It's not broken, it just misses SYSDBA account.

That is not entirely true: the security database is not initialized for
SRP, creating a user (any user) with the SRP user manager should be
enough. If I recall correctly that initialization doesn't automatically
create a SYSDBA account (but I can't check right now).

Mark