> 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

http://www.upscene.com/

Do you care about the future of Firebird? Join the Firebird Foundation:
http://www.firebirdsql.org/en/firebird-foundation/