Which of the following SQL statements will grant the SELECT privilege for the ORDERS table to all database users?
A) GRANT SELECT ON orders TO PUBLIC;
B) GRANT SELECT ON orders TO EVERYONE;
C) GRANT SELECT ON orders TO *;
D) none of the above

Question

Quizplus · Accepted Answer

"PUBLIC" is a keyword in SQL that refers to all database users. Therefore, using "GRANT SELECT ON orders TO PUBLIC" will grant the SELECT privilege to all database users. Option B and C are not valid SQL syntax.

Which of the Following SQL Statements Will Grant the SELECT