2) Consider the relational database state COMPANY attached to this exam. Suppose that all the relations were created by (and hence are owned by) user X, who wants to grant the following privileges to user accounts A, B, C, D, and E:

2.1 Account A can retrieve or modify any relation except DEPENDENT and can grant any of these privileges to other users.

2.2 Account C can retrieve or modify WORKS_ON but can only retrieve the Fname, Minit, Lname, Ssn attributes of EMPLOYEE.

2.3 Account D can retrieve any attribute of EMPLOYEE or DEPENDENT and can modify DEPENDENT.

2.4 Account E can retrieve any attribute of EMPLOYEE but only for EMPLOYEE tuples that have Dno = 5.

2.5 Write SQL statement to grant these privileges. Use views where appropriate.

2.1