Exercise 14.02 – modifying users and revoking permissions

The ebike start-up has been very successful, and there have been a few changes. A new developer, called Sarah, was hired, and there is a new mobileapp schema for the mobile app to manage the bikes. Both Sarah and Mike are working on the mobile app. In addition to this, Patrick has asked you to change his password because he has forgotten what it was. You need to change the password that is used for the account used by the web server.

In order to implement this, first, connect to the database and then create an account for the new developer Sarah. Then, modify the accounts of Patrick, Mike, and the web server so that they will be able to access the new schema. Finally, you can change the password of Patrick.

To complete this exercise, follow the steps:

1. Connect to the database.
2. Create an account for the new developer Sarah and grant her permissions on the ebike and mobileapp schemas with the help of the...