ALTER REMOTE SERVICE BINDING (Transact-SQL)
Changes the user associated with a remote service binding, or changes the anonymous authentication setting for the binding.
Applies to: SQL Server (SQL Server 2008 through current version).
The public key in the certificate associated with user_name is used to authenticate messages sent to the remote service and to encrypt a session key that is then used to encrypt the conversation. The certificate for user_name must correspond to the certificate for a login in the database that hosts the remote service.
Permission for altering a remote service binding defaults to the owner of the remote service binding, members of the db_owner fixed database role, and members of the sysadmin fixed server role.
The user that executes the ALTER REMOTE SERVICE BINDING statement must have impersonate permission for the user specified in the statement.
To alter the AUTHORIZATION for a remote service binding, use the ALTER AUTHORIZATION statement.
The following example changes the remote service binding APBinding to encrypt messages by using the certificates from the account SecurityAccount.
ALTER REMOTE SERVICE BINDING APBinding WITH USER = SecurityAccount ;