Which SQL statement correctly grants SELECT permission on the table 'customers' to user 'alice'?

easy📝 Syntax Q3 of 15

SQL - Security Basics

AGRANT SELECT ON customers TO alice;

BALLOW SELECT FROM customers TO alice;

CPERMIT SELECT ON customers FOR alice;

DGIVE SELECT ON customers TO alice;

Step-by-Step Solution

Solution:

Step 1: Recall the correct SQL syntax for granting permissions
The standard syntax uses GRANT, followed by the permission, ON the object, TO the user.
Step 2: Match the syntax to the options
Only GRANT SELECT ON customers TO alice; uses the correct keywords and order.
Final Answer:
GRANT SELECT ON customers TO alice; -> Option A
Quick Check:
Grant syntax = GRANT ... ON ... TO ... [OK]

Quick Trick: Use GRANT ... ON ... TO ... to assign permissions [OK]

Common Mistakes:

Master "Security Basics" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes