| Subject | Re: [firebird-support] Unable to connect to database using SYSDBA & masterkey as password |
|---|---|
| Author | Paul Vinkenoog |
| Post date | 2010-05-13T13:14:48Z |
Milan wrote:
So, in this case, you have to operate on the DB file directly (which requires knowledge of the internal structure), or build a customized version of Firebird. Maybe there are tools that can remove a role without going through the server, but I wouldn't know which.
If it concerns a Firebird 1 file or lower, one could also install InterBase 6.0 beta (not 6.0.1) and use the locksmith account to connect to the database.
Cheers,
Paul Vinkenoog
> AFAIK roles are stored in security database.No, they're in the individual databases, as Alan said.
So, in this case, you have to operate on the DB file directly (which requires knowledge of the internal structure), or build a customized version of Firebird. Maybe there are tools that can remove a role without going through the server, but I wouldn't know which.
If it concerns a Firebird 1 file or lower, one could also install InterBase 6.0 beta (not 6.0.1) and use the locksmith account to connect to the database.
Cheers,
Paul Vinkenoog