Which of the following is the correct syntax to grant UPDATE permission on a table named products to user john?

easy📝 Syntax Q3 of 15

PostgreSQL - Roles and Security

Which of the following is the correct syntax to grant UPDATE permission on a table named products to user john?

AGRANT UPDATE products TO john;

BGRANT UPDATE ON products TO john;

CGRANT ON UPDATE products TO john;

DGRANT UPDATE TO john ON products;

Step-by-Step Solution

Solution:

Step 1: Recall the correct GRANT syntax
The correct syntax is GRANT permission_type ON table_name TO user_name; where permission_type is UPDATE here.
Step 2: Match the syntax to the options
GRANT UPDATE ON products TO john; matches the correct syntax: GRANT UPDATE ON products TO john;
Final Answer:
GRANT UPDATE ON products TO john; -> Option B
Quick Check:
GRANT permission ON table TO user; = correct syntax [OK]

Quick Trick: Use GRANT permission ON table TO user; syntax [OK]

Common Mistakes:

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free