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#:
CREATE VIEW Payroll
SELECT EmpName, Salary, Status
FROM Employee
Where Job NOT IN Manager 'Supervisor'
SQL#:
GRANT SELECT, UPDATE ON Payroll
To Personnel Personnel
SQL#:
REVOKE UPDATE on Payroll From Personnel
After execution of the commands SQL# and SQL# a member of the user group Personnel 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
