Database Management
Accenture PrimermediumDatabase Management08 Dcl & Database Objects

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

GRANT ... TO PUBLIC gives the privilege to all current and future users.

Related Accenture Database Management questions

Practice more Accenture Database Management questions

PrimerDumps has 1400+ primer questions, 2026 mocks and coding hands-on — all free.