Hi kiwicmc,

>> But the question is, why would you want to use isql to modify
>> passwords, instead of gsec, which is designed for this purpose?

> Because gsec is an interactive process and I want full programatic
> control to add this particular user.

gsec can be used in interactive or command-line mode. To add a user:

gsec -a NewUser -pw HisPassword -user sysdba -password masterkey

Or use a connectivity layer like ibpp or IBO, or connect to the
Firebird API yourself.

Querying security.fdb has one drawback: if future Firebird versions
use another security model (maybe it won't even be a db) your app
breaks at this point. But gsec will still be around, and so will the
API functions.


Greetings,
Paul Vinkenoog