>>> Is there a way a user (other than SYSDBA) can change his/her own
>>> password? (Firebird 1.5, 2.1)
>
>> gsec -user <username> -password <password> -modify <username> -pw <newpass>
>
>> and you can also use services API for that
>
> Thanks. I tried that with Firebird 1.5.5 and got this message:
>
> C:\>\Programme\Firebird\bin\gsec -user STEFAN -password stefan -modify STEFAN -pw test
> find/modify record error
> no permission for update/write access to COLUMN FIRST_NAME
>
> With Firebird 2.1.0 it worked OK.
>
> What's going wrong here?

That user can change their own password is a new feature since 2.0. It
isn't possible in FB 1.x.

It might work in 1.x as well, if you explicitely GRANT the proper SQL
privileges to users in security.fdb. I haven't tried it though.


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com