Subject Re: [firebird-support] Old DB - unknown user
Author Thomas Steinmaurer
> Trying to gain access to a couple of old FB 2.0 databases, I can't
> remember what username is set as database owner and has grants to access
> the database.
> On a fresh system with only user "sysdba" and default pwd "masterkey" I
> can't login to these databases. I get error like this (from FlameRobin):
> SQL message: -551
> This user does not have privilege to perform this operation on this object.
> Engine Code: 335544352
> Engine Message:
> no permission for read-write access to database
> Is there any way to find out what user I should login as?
> I assume I can setup a user by that name on my fresh system, with any
> password, and then connect...?

Have you tried accessing the database with SYSDBA via isql?

Then you can do a:

show database;

There you will see the owner of the database.

With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

Do you care about the future of Firebird? Join the Firebird Foundation: