Subject Re: [firebird-support] Re: Changing user password from isql
Author Helen Borrie
At 11:34 PM 3/06/2004 +0000, you wrote:
>--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
>wrote:
> > But the question is, why would you want to use isql to modify
>passwords,
> > instead of gsec, which is designed for this purpose?
> >
> > /heLen
>
>Because gsec is an interactive process and I want full programatic
>control to add this particular user. I don't actually want to use isql
>either, I should have said use SQL to modify ....

Then no. User names and passwords are not defined at database level, but
at server level. There is no SQL language support for modifying them
(though there is for creating roles and for granting and revoking SQL
permissions...)

However, it can be done through the APIs (either the general API or the
Services API).

/heLen