Your database administrator has disallowed a group of users from making alterations to the Employees table in your corpo
Posted: Sat Jul 23, 2022 7:29 pm
Your database administrator has disallowed a group of users from making alterations to the Employees table in your corporate database. The users, known as
Group_2, previously had full privileges with the Employees table. Which of the following SQL statements properly removes any alteration privileges from Group_2?
A. REVOKE INSERT, UPDATE, DELETE ON Employees FROM Group_2;
B. REVOKE UPDATE FOR Employees FROM Group_2;
C. REVOKE INSERT, UPDATE, DELETE ON Employees FOR Group_2;
D. REVOKE UPDATE, DELETE FOR Employees FROM Group_2;
Group_2, previously had full privileges with the Employees table. Which of the following SQL statements properly removes any alteration privileges from Group_2?
A. REVOKE INSERT, UPDATE, DELETE ON Employees FROM Group_2;
B. REVOKE UPDATE FOR Employees FROM Group_2;
C. REVOKE INSERT, UPDATE, DELETE ON Employees FOR Group_2;
D. REVOKE UPDATE, DELETE FOR Employees FROM Group_2;