Introduction to user permissions

In the previous chapter, we learned how to make modifications to the data stored in MySQL tables and collections. Additionally, we learned how to use the DELETE statement to delete rows and the UPDATE statement to change existing rows. For both statements, we learned how to use them together when joining multiple tables to allow for more complex changes. Additionally, we learned how to use the INSERT statement with an ON DUPLICATE KEY UPDATE clause to add new records to the database or update an existing record if it was already in the database. We learned how to use the modify() method to modify existing documents in a collection and the remove() method to remove documents from a collection.

In this chapter, we will learn how to create users to segregate and restrict access to ensure no accidental or fraudulent changes can be made to the data.

Good management of accounts and passwords is paramount to security. For example, let's suppose...