Which of the following is the correct syntax to grant SELECT permission on table employees to user john?

easy📝 Syntax Q12 of 15

PostgreSQL - Roles and Security

Which of the following is the correct syntax to grant SELECT permission on table employees to user john?

AGRANT ON employees SELECT TO john;

BGRANT john ON employees SELECT;

CGRANT SELECT TO john ON employees;

DGRANT SELECT ON employees TO john;

Step-by-Step Solution

Solution:

Step 1: Recall correct GRANT syntax
The correct syntax is: GRANT permission ON object TO user;
Step 2: Match syntax with options
GRANT SELECT ON employees TO john; matches the correct order: GRANT SELECT ON employees TO john;
Final Answer:
GRANT SELECT ON employees TO john; -> Option D
Quick Check:
GRANT + permission + ON + object + TO + user [OK]

Quick Trick: GRANT permission ON object TO user; is the pattern [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