At 07:03 PM 14-08-02 +1000, you wrote:

>yeh but you need to copy the known encrypted password back into the existing
>password field so you can maintain all the other users don't you?
>copy and paste should do it it no?

No. You work the other way around.

Rename the unusable isc4.gdb then restore the isc4.gbk that ships with the
distribution. Log in with SYSDBA/masterkey, since this is now the login
for the whole server. Change the SYSDBA password (might be a bright idea to
write it down and lock it up somewhere).

Then use a tool or write an application to pump all of the records from
USERS in the renamed file into USERS in the restored one - all except WHERE
USER_NAME='SYSDBA' of course.

heLen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
______________________________________________________________________