Subject Re: [firebird-support] Unable to connect to database using SYSDBA & masterkey as password
Author Milan Tomeš - Position
Dne 13.05.2010 15:20, Alan McDonald napsal(a):
>
> >
> > I see. Roles were stored in security database in older versions (like
> > 1.0 or 1.5).
>
> Hmmm, sorry - never before in Interbase or Firebird. Roles have always
> been
> in the DB.
> Alan
>

LOL it's longer than I thought so I don't remember it exactly. I did the
trick with adding SYSDBA role (using insert command into RDB$ROLES) and
I'm pretty sure that I added this role into RDB$ROLES into security
database. I still have a source code, that makes some changes in
security database and one of this change is granting all rights to my DB
owner user with grant option.

Milan

>
> I've used that trick in the past, but I removed it long
> > time ago and didn't read any change of this. So it's my mistake and I'm
> > sorry for my bad information.
> >
> > Milan
> >
>
>


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