> Milan wrote:
>
> > 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.

I'd forgotten about that - was that the backdoor account?
Alan

>
>
> Cheers,
> Paul Vinkenoog
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>