Which of the following SQL statements will grant all object privileges for the ORDERS table to user RTHOMAS?
A) GRANT ALL ON orders TO rthomas;
B) GRANT * ON orders TO rthomas;
C) GRANT ALL OBJECTS ON orders TO rthomas;
D) GRANT ALL OPRIVS ON orders TO rthomas;

Question

Quizplus · Accepted Answer

The correct syntax to grant all object privileges for a table is "GRANT ALL ON table_name TO user_name". Choice A correctly follows this syntax, while choice B is not valid SQL syntax, choice C is not a valid option for granting object privileges, and choice D uses incorrect syntax for granting object privileges.

Which of the Following SQL Statements Will Grant All Object