Assume that a user root with a password 'root' has created a database called THERAPY and inside the

database the user root has created the tables given on page $4$ of the examination. $($Note: you are to ignore

the changes made in question $3)$

Write SQL statements that performs the action listed in the following as a user root.

$($a$)$ The user root would like to create a new user account called Jabesh with a password

'verypower'. The total number of times Jabesh can connect to the server per hour must be set to

$11.($Note: you can only use one SQL statement$)$

$($b$)$ The new user Jabesh must have the rights to execute CREATE TABLE and CREATE VIEW

statements in the database THERAPY with right to propagate the privilege to the other users.

$($c$)$ The new user Jabesh must have access in write mode to the relational tables THERAPIST, BRANCH

with NO right to propagate such privilege to other users.

$($d$)$ The new user Jabesh must have the UPDATE privilege to a relational table BRANCH and column

BranchName with rights to propagate the privilege to the other users.

$($e$)$ The management wanted to remove all privileges from an existing user Jabesh to the database

THERAPY.