Hello Tomas,

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

Connect with another user name, for example, the database owner.

Your customer should be able to supply you with log-in details (at
least a name), next, create such a user at your system and you should
be able to log in.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com