The following three SQL statements are executed one after the other.
SQL#1:
CREATE VIEW Payroll
SELECT EmpName, Salary, Status
FROM Employee
Where Job NOT IN ('Manager', 'Supervisor')
SQL#2:
GRANT SELECT, UPDATE ON Payroll
To Personnel1, Personnel2
SQL#3:
REVOKE UPDATE on Payroll From Personnel2

-After execution of the commands SQL#1,SQL#2,and SQL#3,a member of the user group Personnel2 may:
A) Access the Salary of an Employee whose job is 'Clerk'
B) Change the Salary of any Employee
C) Access the Salary of any Employee
D) Change the Salary of an Employee whose job is 'Clerk'

Question

The following three SQL statements are executed one after the other.
SQL#1:
CREATE VIEW Payroll
SELECT EmpName, Salary, Status
FROM Employee
Where Job NOT IN ('Manager', 'Supervisor')
SQL#2:
GRANT SELECT, UPDATE ON Payroll
To Personnel1, Personnel2
SQL#3:
REVOKE UPDATE on Payroll From Personnel2

-After execution of the commands SQL#1,SQL#2,and SQL#3,a member of the user group Personnel2 may:
A) Access the Salary of an Employee whose job is 'Clerk'
B) Change the Salary of any Employee
C) Access the Salary of any Employee
D) Change the Salary of an Employee whose job is 'Clerk'

Quizplus · Accepted Answer

CSQL#1 creates a view named Payroll that includes employees who are not Managers or Supervisors. SQL#2 grants SELECT and UPDATE permissions on the Payroll view to Personnel1 and Personnel2. SQL#3 revokes UPDATE permission from Personnel2, leaving them with only SELECT permission on the Payroll view. Therefore, a member of Personnel2 can access (SELECT) the salary of any employee included in the Payroll view (which would include Clerks, as they are not excluded by the view's definition) but cannot change (UPDATE) the salary of any employee since the UPDATE permission has been revoked.

The Following Three SQL Statements Are Executed One After the Other