Subject Re: [IBO] UPDATE the users-table in isc4.gdb
Author Geoff Worboys
> Thanks, but I already have that article. What I'm looking for is the
> SQL-code that encrypts the passwords when using UPDATE (or INSERT).

There is no such thing as SQL-code that will do this. To do your own
encyrption you must setup an insert statement directly against the
passwd field of the USERS table and encyrpt the value yourself in code
before performing the insert. There is pascal code that is supposed
to do this; available in the unixpass.pas unit distributed with IBO.

Exactly why you should want to do this I do not know - perhaps you are
still using IB4.2?? With IB5 and later It would be much safer to use
the API, especially since you can expect changes to the security in
later releases of Firebird (or at least I hope so).

Geoff Worboys
Telesis Computing