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

The role probably has been created to avoid accessing the database with
SYSDBA, thus new objects won't have SYSDBA as owner then.

The database and the objects inside the database hopefully have a
different owner than SYSDBA, so you'd best ask the customer the name of
the Firebird user who is the owner of the database and objects. Then,
create an equally named user in your Firebird installation and use this
user for connecting to the database.


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/