title: Use ALTER LOGIN to change User's own Password
body: <p>I have a stored procedure that runs the following:</p>
  
  <pre><code>'ALTER LOGIN ' + @Login + ' WITH PASSWORD = ''' + @Password + ''''
  </code></pre>
  
  <p>I get the following error message:</p>
  
  <p>Cannot alter the login 'aUser', because it does not exist or you do not have permission.</p>
  
  <p>HOWEVER, if I make add the user to the SysAdmin role, then it is successful. If I remove the user from SysAdmin, I get the error message again, so it appears to be user rights.</p>
  
  <p>The problem is, I need users to be able to change their own passwords, and the ALTER LOGIN command does not seem to allow for that, even though <a href="http://msdn.microsoft.com/en-us/library/ms189828.aspx" rel="noreferrer">MSDN</a> says:</p>
  
  <blockquote>
    <p>A principal can change the password, default language, and default database for its own >login.</p>
  </blockquote>
  
  <p>Anyone got any ideas?</p>