title: SQL Server - Create user that can only read and write data from and to database
body: <p>I need to share my project with some colleagues, and I want to create a SQL Server user for them, so that user should not be able to drop database, I need him only to read and write to SQL Server tables, so I'm wondering are these settings ok:</p>
  
  <p><a href="https://i.stack.imgur.com/DZdFg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DZdFg.png" alt="enter image description here"></a></p>
  
  <p>And here is another settings:</p>
  
  <p><a href="https://i.stack.imgur.com/F8p7g.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/F8p7g.png" alt="enter image description here"></a></p>
  
  <p>Is this enough to prevent them from dropping database? But also enough to give them access to read and write the database? Maybe I checked something that I shouldn't?</p>