[Solved] Consider this command:GRANT UPDATE ON customers TO ;What is the error in this command? — Ans: Missing user name after TO keyword. | PostgreSQL

PostgreSQL - Roles and Security

Consider this command:

GRANT UPDATE ON customers TO ;

What is the error in this command?

AMissing user name after TO keyword.

BUPDATE is not a valid permission.

CTable name is missing after ON keyword.

DGRANT cannot be used for UPDATE permission.

Step-by-Step Solution

Solution:

Step 1: Check syntax completeness
The command ends with TO but does not specify a user or role name.
Step 2: Validate permission and table name
UPDATE is a valid permission and customers is the table name, so those parts are correct.
Final Answer:
Missing user name after TO keyword. -> Option A
Quick Check:
GRANT requires user after TO [OK]

Quick Trick: Always specify user after TO in GRANT [OK]

Common Mistakes:

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Consider this command: