Which of the following is a valid SQL command?
A) GRANT SELECT ON orders TO rthomas WITH ADMIN OPTION;
B) GRANT SELECT TO rthomas;
C) GRANT SELECT ON orders TO rthomas WITH GRANT OPTION;
D) none of the above

Question

Quizplus · Accepted Answer

A) is incorrect because it includes "WITH ADMIN OPTION," which is not a valid option.
B) is incorrect because it does not specify the table or view that the user is granted access to.
C) is correct because it grants the user "rthomas" the ability to select data from the "orders" table and also allows them to grant that same access to other users.

Which of the Following Is a Valid SQL Command