Subject | Re: [IBO] Difficulties of inclusion of users in security.fdb |
---|---|
Author | Helen Borrie |
Post date | 2008-04-18T14:46:24Z |
At 11:27 PM 18/04/2008, you wrote:
Helen
>OK. I'm SYSDBA user.The same error would occur if the user were not the SYSDBA, too. Why not catch this error and display a message meaning "Either this user already exists or you are not authorised to add a 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.'
Helen