OK. I'm SYSDBA user.

Sorry to be insisting on this topic but must go through him, and also
sorry for my bad English.

May code is :

try
DMMain.DbMain.AlterUser(uaAddUser,
QryL180L180_ID.AsString,
QryL180L180_SENHA.AsString,
'',
QryL180L180_ID.AsString,
'',
'' )
Except
end;

If the user who is being briefed by variable qryl180l180_ID not exist
in the database the system works well but if it already exists in the
database it returns the error.

What I am stating is whether the user already exists for not miss the
line of insert, but the update, or otherwise able to handle this message
that returns from the database so that does not appear to the end user.

message error is:

exception class EIB_ISCError with message 'ISC ERRORCODE:335544754 - An
error occurred while attempting to add the user.'

Thanks for your help.

Flavio

Helen Borrie escreveu:

>
> At 10:49 PM 18/04/2008, you wrote:
> >Actually the problem is that I do not know if the user has already
> >created this in the database. I need to know this to decide whether the
> >action to be executed is inclusion or change in the users of security.
>
> Ordinary users cannot create records in security.fdb. Only SYSDBA can
> do it.
>
> In Fb 2, users are allowed to change their own password. In Fb 1.5,
> only SYSDBA can do it.
>
> Helen
>
>

[Non-text portions of this message have been removed]