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

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
1- After execution of the commands SQL#1 and SQL#2, a member of the user group Personnel2 may:
a) Change the Salary of any Employee
b) Access the Salary of any Employee
c) Change the Salary of an Employee whose job is 'Clerk'
d) All of the above

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!