Effects of Using the Untrusted Mode

The effects of the untrusted mode depend on the user’s client program.

isql and some user applications require that logins have the same password on the remote server and the local server. You can write Open Client applications to allow local logins to have different passwords on different servers.

To change your password in “untrusted” mode, you must first change it on all the remote systems you access before you can change it on your local server. If you change your password on the local server first, when you issue the remote procedure call to execute alter login on the remote server, your passwords no longer match.

The syntax for changing your password on the remote server is:

remote_server...alter login login_name 
    with password, caller_passwd
    modify password [immediately] new_password ]

See Security Administration Guide > Managing SAP ASE Logins and Database Users.