Which of the following SQL commands lets user Mendez select data from the Projects table but not take any other action?
A)GRANT INSERT ON Projects TO Mendez;
B)GRANT SELECT ON Projects TO Mendez;
C)REVOKE SELECT ON Projects TO Mendez;
D)ALLOW SELECT ON Projects TO Mendez;

Question

Quizplus · Accepted Answer

The SQL command "GRANT SELECT ON Projects TO Mendez;" specifically grants the user Mendez the permission to select (or query) data from the Projects table, without granting any other type of access or action such as insert, update, or delete.

Which of the Following SQL Commands Lets User Mendez Select