> At 07:57 AM 10/11/2003 +0100, you wrote:
> >Hello,
> >I dropped SYSDBA in an error, and i don't now how to recreate it!
>
> Errrm. No backup of the security database?

Thanks, it's all ok now :-)
I used a backup of isc4.gdb, i restored it and now it works fine.

> >help please!
>
> OK. I hope you're not really a spiv pretending to be a DBA all in a

muddle.

> :-)
>
> Move or rename your security database.
> Then, use GBAK to restore the file security.fbk (or isc4.gbk on Fb
> 1.0). Find these files in your Fb root directory. The SYSDBA password
> should be 'masterkey'.
>
> I hope you've at least got a listing of user names somewhere, so you can
> rebuild the database. It doesn't matter about the passwords - you can

give

> them new ones.
>
> Alternatively, once you are back up and running with the new sec.

database,

> you should be able to log into the other one and treat it just as an
> ordinary database (not certain - haven't tried...) If so, then you could
> pump the user records into the new one.
>
> This all demonstrates how easy it is to steal the sysdba's identity on an
> insecure server....
>
> h.
>
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>