[Solved] Identify the error in this SQL command:GRANT SELECT employees TO user_mary; — Ans: Missing ON keyword before table name | SQL

SQL - Security Basics

Identify the error in this SQL command:
GRANT SELECT employees TO user_mary;

ASELECT permission cannot be granted

BIncorrect user name format

CTO keyword should be replaced with FOR

DMissing ON keyword before table name

Step-by-Step Solution

Solution:

Step 1: Review correct GRANT syntax
The correct syntax is GRANT permission ON object TO user.
Step 2: Spot the missing ON keyword
The command lacks ON before the table name 'employees'.
Final Answer:
Missing ON keyword before table name -> Option D
Quick Check:
GRANT syntax requires ON keyword [OK]

Quick Trick: GRANT needs ON before object name [OK]

Common Mistakes:

Master "Security Basics" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Identify the error in this SQL command: