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;



CCC Online Test 2021 CCC Practice Test Hindi Python Programming Tutorials 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 Bank SSC Railway TET UPTET Question Bank career counselling in allahabad Sarkari Naukari Notification Best Website and Software Company in Allahabad Sarkari Exam Quiz