Assume that a user root with a password 'csit$115\text{'}$ created a database called banks. The user

executed CREATE TABLE statements given on page $4$ of the examination paper to create the

relational tables in the database banks. The user root nominates a database banks as a default

database.

Write SQL script that performs the following operations as a user root. Assume that a user root is

already connected to the database.

$(1)$ The user root creates two users: clerk and manager.

$(1$ mark$)$

$(2)$ The user root grants the read and write access rights on relational table ACCOUNT to the

manager. The read and write access rights cannot be propagated to other roles or users.

$(1$ mark$)$

$(3)$ The user root grants the rights to insert the rows into relational tables TRANSACTION to

clerk. The access rights can be propagated to other roles or users.

$(1$ mark$)$

$(4)$ The user root grants the update privilege on all relational tables in the banks database to the

manager. The privilege cannot be propagated to other roles or users.

$(1$ mark$)$

$(5)$ The user root grants the read access rights to information about the account number, bank

name, and the total number of transactions happened for each account to the manager. The

privilege cannot be propagated to other roles or users.

$(2$ marks$)$

$(6)$ The user root sets the resource limits for the users created in step $(2)$ and it allows maximum $3$

concurrent connections.