title: "GRANT ALL TO role" in SQL Server
body: <p>Please can someone explain what the following statement does in SQL Server 2005:</p>
  
  <pre><code>GRANT ALL TO pax_writer
  </code></pre>
  
  <p>pax_writer is a database role previously created using the statement</p>
  
  <pre><code>CREATE ROLE pax_writer AUTHORIZATION dbo
  </code></pre>