Subject Re: [firebird-support] Unable to connect to database using SYSDBA & masterkey as password
Author Milan TomeŇ° - Position
Dne 13.05.2010 14:31, Alan McDonald napsal(a):
>
> >
> > Hi,
> >
> > you're fighting with a trick that's used for disabling SYSDBA
> > connection. Simple solution is to replace security database with the
> > one
> > that is shipped with Firebird and then connect to the database using
> > SYSDBA user.
> >
> > HTH
> >
> > Milan
>
> You sure?
> the role is on the DB, no amount of changing the security DB will permit
> SYSDBA to connect to it.
> You need to be able to remove that role in the database before you move it
> to your other server.
> Alan
>

AFAIK roles are stored in security database.

Milan

> >
> > Dne 13.05.2010 14:04, Harish napsal(a):
> > >
> > > I have copied a database to my system from a different server. I dont
> > > know the user name & password of that database. I tried to connect to
> > > the copied database on my system with user SYSDBA & password as
> > > masterkey. It gives following error message.
> > >
> > > "Your Login SYSDBA is same as one of the SQL role name. Ask your
> > > database administrator to setup a valid FireBird Login".
> > >
> > > Can anybody help me to connect to this database. How can I proceed.
> > >
>
>


[Non-text portions of this message have been removed]