Instructions
For each of the following, write SQL statements to create views where needed and to grant the indicated privileges for the University database with this schema: Student (stuId, lastName, firstName, major, credits) Faculty (facId, name, department, rank) Class (classNumbe, facId, schedule, room) Enroll (stuId, classNumber, grade) Give permission to read the tables Student and Class to user 201. Create a view of Enroll that does not include the grade attribute, and give user 201 permission to read and update the view. Create a role that includes reading Student, Class, and the view created in 2. Give that role to all clerks in the Deans office, which includes users 202, 203, 204, and 205. Give permission to user 206, an assistant dean, to read and modify (insert, delete, update) the Faculty and Class tables. This user can authorize others to read and modify Class but not Faculty. User 206 authorizes user 300 to read Class. Write the command to do this.