title: httpbasic + apikey and multitenancy
body: <p>I'm about to implement httpbasic + apikey authentication with multitenancy.
  What I mean... I'd like to create procedure with input parameters for username, password and apikey, so that users could use it with their own credentials, not only with stored default creds.</p>
  
  <p>Below is how it works in sql without multitenancy.</p>
  
  <pre><code>EXEC SYSADMIN.createConnection("name" =&gt; 'webservice1',  "jbossCLITemplateName" =&gt; 'name1',  "connectionOrResourceAdapterProperties" =&gt;  'EndPoint=https://api.example.com/api/,SecurityType=HTTPBasic,AuthUserName=[EMAIL]',  "encryptedProperties" =&gt; 'AuthPassword=[PASSWORD]') ;;
  
  EXEC SYSADMIN.createDataSource("name" =&gt; 'webservice1',  "translator" =&gt; 'name1', "modelProperties" =&gt; '',  "translatorProperties" =&gt; '', "encryptedModelProperties" =&gt; '',  "encryptedTranslatorProperties" =&gt; '') ;;
  
  exec  webservice1.invokeHTTP(endpoint=&gt;'2.0/checks',requestHeaders=&gt;  App-Key: myapikey1  ,action=&gt;'GET',requestContentType=&gt;'application/xml')
  </code></pre>
  
  <p>Now I'm trying to create connection without authusername and authpassword and it does work</p>
  
  <pre><code>EXEC SYSADMIN.createConnection("name" =&gt; 'webservice1',  "jbossCLITemplateName" =&gt; 'name1',  "connectionOrResourceAdapterProperties" =&gt;  'EndPoint=https://api.example.com/api/,SecurityType=HTTPBasic') ;;
  
  EXEC SYSADMIN.createDataSource("name" =&gt; 'webservice1',  "translator" =&gt; 'name1', "modelProperties" =&gt; '',  "translatorProperties" =&gt; '', "encryptedModelProperties" =&gt; '',  "encryptedTranslatorProperties" =&gt; '') ;;
  </code></pre>
  
  <p>but then I'm trying to call my webservice with credentials entered manually</p>
  
  <pre><code>exec  webservice1.invokeHTTP(endpoint=&gt;'2.0/checks',requestHeaders=&gt;  AuthUserName: user1 || AuthPassword: pass1 || App-Key:  myapikey1,action=&gt;'GET',requestContentType=&gt;'application/xml')
  </code></pre>
  
  <p>and receive error:</p>
  
  <blockquote>
    <p>Server returned HTTP response code: 401 for URL: <a href="https://api.example.com/api//2.0/test1" rel="nofollow">https://api.example.com/api//2.0/test1</a>** http error stream***{"error":{"statuscode":401,"statusdesc":" Unauthorized","errormessage":"User credentials missing"}}</p>
  </blockquote>
  
  <p>How do I pass username and password for httpbasic auth properly without need to recreate the connection for different user?
  Please advise.</p>