Which sql statement is used to grant select privileges on all tables in a database to a user

MCQ Answer

Which SQL statement is used to grant SELECT privileges on all tables in a database to a user?

Topic : Database Fundamentals

A. GRANT SELECT ON database.* TO user;

B. GRANT ALL PRIVILEGES ON database.* TO user;

C. GRANT DATABASE SELECT TO user;

D. GRANT USER SELECT ON database.*;

Correct Answer is :

A. GRANT SELECT ON database.* TO user;