Solution to Activity 14.1

Perform the following steps to achieve the goal of this activity:

1. Connect to the database server. As you will be working with the world database, write the following:

   USE world

Again, there is no need to connect to a specific schema; just connect with an account that has enough permissions to give out grants.

2. Create roles for manager and language_expert and grant permissions to language_expert:

   CREATE ROLE 'manager';
   GRANT ALL ON world.* TO 'manager';
   CREATE ROLE 'language_expert';
   GRANT ALL ON world.countrylanguage TO 'language_expert';

3. Create an account for webserver and grant permissions to the user created for webserver:

   CREATE USER 'webserver'@'%' IDENTIFIED BY '1twedByutGiawWy';
   GRANT SELECT ON world.* TO 'webserver'@'%';

4. Create an account for intranet and grant permissions to the user created for intranet:

   CREATE USER 'intranet&apos...