Hi.

I'm really new to Firebird.

Situation: customer used some IS based on firebird and he wants to
migrate to our IS based on another DB. He provided us the datafile
something.fdb, so we can read old data from it.

Problem: I've downloaded and installed FirebirdCS-2.1.1.17910-0.i686
on Linux. The installation script asked me for SYSDBA password. When I
try to connect to this datafile via iSQL (./isql and then connect
/full/path.fdb;) it returns:
Statement failed, SQLCODE = -902
Your login SYSDBA is same as one of the SQL role name. Ask your
database administrator to set up a valid Firebird login.

I've found, that this is some kind of security feature - there is a
role called sysdba, which isn't allowed to connect. The work-around
should be to drop this role.

Question: (finally) Althrough i've found that I should drop this role
to be able to connect and read data from FDB, I've never found how to
do this.

Thank you for any answer.