> 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/
