Which of the following SQL statements properly removes any alteration privileges from Group_2?

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?

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;



Leave a Reply 0

Your email address will not be published. Required fields are marked *