6 Question No. 1: Authorization 14 marks) aWhat privileges are needed for a user to execute the following SQL statement over tables Employee(ID, salary, rank, deptID) and Department (ID, category)? 12 Update Employee E1 Set salary = (Select Avg (salary) From Employee E2 Where El.rank - E2.rank) Where dept ID In (Select ID from Department where category - 'Sales') Consider a table T(A,B,C) with owner Ali, and the following sequence of statements related to privileges on T. Each statement is prefaced with the user issuing it. Ali: Grant Select, Delete on T to Babar With ant Option Ali: Grant Select, Delete on T to Chishti With Grant Option Babar: Grant Select (A,B), Delete on T to Daud With Grant Option Chishti: Grant Select (A,C) on T to Daud With Grant Option Daud: Grant Select (A), Delete on T to E22ah Ali: Revoke Select, Delete on TFrom Babar Cascade What privileges on table T does Ezzah have after this sequence of statements? (2) hospoli.com