At 11:37 AM 23/12/2004 +0000, you wrote:

>in Mysql i can write something like this:
>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

Firebird is a multi-database server and passwords are stored in the
security database (security.fdb). There is a tool, accessible by the
SYSDBA user, for adding and modifying users and passwords. The name of the
tool is GSEC. You will find it in the /bin directory of your Firebird
server installation.

Read Chapter 34 of The Firebird Book for full docs for gsec; or get hold
of OpGuide.pdf from the InterBase 6 doc set.

Anyway, briefly, to change a password:

bin]$ ./gsec -modify auser -pw rudolf81 -user sysdba -password ectoplas

Or you can do the same thing in gsec's own shell:

bin]$ ./gsec -user sysdba -password ectoplas
GSEC>modify auser -pw rudolf81
GSEC>add santa -pw oldsofty
GSEC>delete badguy
GSEC>quit
bin]$

There are programmatic ways to do it, too, largely dependent on your client
programming interface.

./hb