Which SQL statement grants a privilege to all the database users?
Answer options
A
GRANT SELECT ON employees TO PUBLIC;
B
GRANT SELECT ON employees TO ALL;
C
GRANT ALL ON employees;
D
GRANT SELECT ON employees TO USERS;
Correct answer: GRANT SELECT ON employees TO PUBLIC;
Explanation
Quick AnswerThe correct answer is GRANT SELECT ON employees TO PUBLIC; because it directly addresses the core logic of Database Management.
GRANT ... TO PUBLIC gives the privilege to all current and future users.