title: SQL Server 2008: how do I grant privileges to a username?
body: <p>I need to be able to establish an ODBC connection through SQL Server authentication. </p>
  
  <p>In SSMS how do I grant permission for a user to be able to have ALL RIGHTS on a specific database?</p>
  
  <p>is there a way to do this graphically with SSMS?</p>