title: User Mapping SQL Management Studio
body: <p>I am using the sp_addrolemember procedure to give a user access.  The command works but can anyone explain why the "Map" checkbox isn't checked under the "User Mapping" in the their properties? Or is there a way to have the box checked?  </p>
  
  <p>I am using a HTML interface with Python to give users access but if I go into SQL Management Studio it is confusing because it looks like they don't have permission when just scrolling through mappings for that user.</p>
  
  <pre><code>USE [105494-0000] EXEC sp_addrolemember 'permission', 'user_name'
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/1jprg.png" alt="enter image description here"></p>
  
  <p><img src="https://i.stack.imgur.com/LXk8i.png" alt="enter image description here"></p>