Subject | RE: [firebird-support] in MySql i use PASSWORD. what can i use in FireBird ? |
---|---|
Author | Alan McDonald |
Post date | 2004-12-23T11:55:37Z |
> in Mysql i can write something like this:This isn't MySQL. PASSWORD is not a standard SQL function.
> UPDATE mysql.user SET Password=PASSWORD('newpass')
>
> in Firebird i get this:
> ErrMsg :
> Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char
> 54 PASSWORD ErrCode : -104
>
> when i write this:
> SELECT * FROM utilizatori WHERE id = "x" AND pass = PASSWORD("x")
>
> if someone knows how to solve this please answer
> Thank You
There is an UDF to encrypt passwords f_ibpassword() if you install the
freeudf library.
Alan