title: TSQL granting read and write permissions to all tables
body: <p>Is setting </p>
  
  <pre><code>EXEC sp_addrolemember N'db_datareader', N'User'
  EXEC sp_addrolemember N'db_datawriter', N'User'
  </code></pre>
  
  <p>Is the same as granting SELECT/INSERT/DELETE/UPDATE on all tables to User</p>
  
  <pre><code>GRANT SELECT ON  [Schema].[Table] TO [User]
  GRANT INSERT ON  [Schema].[Table] TO [User]
  GRANT DELETE ON  [Schema].[Table] TO [User]
  GRANT UPDATE ON  [Schema].[Table] TO [User]
  </code></pre>