This example assumes that your login is “mary” and you want to use the DCE security mechanism with unified login (always in effect when you specify the -V option of isql or bcp), message confidentiality, and mutual authentication for remote procedures. You want to connect to server WOND and run remote procedures on GATEWAY with mutual authentication. Assuming that a system security officer has set up both WOND and GATEWAY for rpc model B, added you as a user on both servers, and defined you as a remote, “trusted” user on GATEWAY, you can use the following process:
Log in to the DCE security mechanism and receive a credential:
dce_login mary
Log in to the Adaptive Server with isql:
isql -SWOND -Vcm
Run:
GATEWAY...sp_who GATEWAY...mary_prc1 GATEWAY...mary_prc2
Now, all messages that Mary sends to the server and receives from the server are encrypted (message confidentiality), and when she runs remote procedures, both the WOND and GATEWAY servers are authenticated.
