Example of using security services

Assume 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_dce or bcp_dce), 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:

  1. Log in to the DCE security mechanism and receive a credential:

    dce_login mary
    
  2. Log in to the Adaptive Server with isql_dce:

    isql_dce -SWOND -Vcm
    
  3. Run:

    GATEWAY...sp_who
    GATEWAY...mary_prc1
    GATEWAY...mary_prc2
    

Now, all messages that Mary sends to the server and receives from the server will be encrypted (message confidentiality), and when she runs remote procedures, both the WOND and GATEWAY servers will be authenticated.