A custom XPress Dynamic connector is built using jdbc against Sybase.
An operation binding is defined when an account is modified to call the Sybase "dbo.sp_password" stored procedure, passing "caller_passwd", "new_passwd" and "loginame".
This operation binding fails with: SQL state [ZZZZZ]; error code ; “Invalid caller's password specified, password left unchanged.”
Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command.
This is not a self-password change. The data source is setup using a proxy admin user (e.g.: "caim"), the password reset is being done for another user (e.g.: "catest").
No attribute on the endpoint (sybase) does hold the caller's password (e.g.: "caim" user password), and we cannot set free text for the "Caller's Password" field into the "sp_password" procedure in the operation binding configuration.