Hello,

Our program allows the user to change their own userid/password,
and we do this by calling the IBO AlterUser procedure.
However, I am having a problem knowing where to put the AlterUser.

Currently, I have it in the BeforePost of the table containing all
the user information. This is a bad place to put it because of the
following steps:
1) User changes userid/password
2) User posts information.
3) Program goes through BeforePost which calls AlterUser.
4) User goes 'Ooops' and hits Rollback which reverts all data to
the original data except that the Userid/password have been changed.

So I think that the BeforeCommitRetaining is the best place,
however, that is still not 100% since the program could go into the
BeforeCommitRetaining, do the AlterUser, and then the Commit dies.
Again, its the same problem although there is a much less chance of
screw-ups this way... but not perfect.

So how do other IBO users handle the ability for the user to
change their own userid/password (without having to go into external
programs like IB_SQL OR GSEC).

Thanks for any advise. Eric.