Report Bug

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


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.*;


Solution
A. GRANT SELECT ON database.* TO user;



Online Exam Quiz for One day Exam Online Typing Test CCC Online Test 2026 Best Computer Training Institute in Prayagraj (Allahabad) Best Java Training Institute in Prayagraj (Allahabad) Best Python Training Institute in Prayagraj (Allahabad) O Level Online Test in Hindi Best Website and Software Company in Allahabad