Which PostgreSQL feature helps restrict user access to specific tables?

easy📝 Syntax Q3 of 15

PostgreSQL - Roles and Security

AVACUUM

BCREATE INDEX

CGRANT command

DEXPLAIN

Step-by-Step Solution

Solution:

Step 1: Identify commands related to access control
GRANT is used to give permissions to users on tables.
Step 2: Understand other commands are unrelated
CREATE INDEX speeds queries, VACUUM cleans storage, EXPLAIN shows query plans.
Final Answer:
GRANT command -> Option C
Quick Check:
Access control command = GRANT [OK]

Quick Trick: Use GRANT to control who can access tables [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