Which of the following commands will revoke the SELECT privilege for the ORDERS table previously granted to user RTHOMAS?
A) REVOKE SELECT FROM rthomas;
B) REVOKE SELECT ON orders FROM rthomas;
C) REVOKE SELECT FOR orders FROM rthomas;
D) UNGRANT SELECT FROM rthomas;

Question

Quizplus · Accepted Answer

To revoke a specific privilege on a specific table previously granted to a user, we use the REVOKE command with the specific privilege and table name, followed by the user's name. The correct syntax is: `REVOKE privilege ON table_name FROM user_name;` Therefore, the correct command to revoke SELECT privilege on the ORDERS table granted to user RTHOMAS is: `REVOKE SELECT ON orders FROM rthomas;`.

Which of the Following Commands Will Revoke the SELECT Privilege