Subject RE: [ib-support] PASSWORD() function ?
Author Bender Heri
> -----Original Message-----
> From: Riste Pejov [mailto:ristep@...]
> Sent: Wednesday, September 04, 2002 12:01 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] PASSWORD() function ?
>
>
> Does FB have a PASSWORD function ?
>
> I would like to generate the encrypted password the same way
> it is stored in
> isc4.gdb
> so i could then update user password in something like this:
> (using isc4.gdb)
>
> UPDATE users SET password=PASSWORD("secret_pass") WHERE
> user="my_user";
>
> if anyone used MySQL he would probably know what i wanna do :)
>

I think there is no such function. But you can use the API function
ISC_ADD_USER to manipulate the ISC4.gdb database

Heri