[Solved] Consider the command:GRANT CREATE ON SCHEMA sales TO user1;But user1 cannot create tables in sales. What is the likely cause? | PostgreSQL

PostgreSQL - Roles and Security

Consider the command:
GRANT CREATE ON SCHEMA sales TO user1;
But user1 cannot create tables in sales. What is the likely cause?

AUser1 does not have SELECT privilege on sales

BUser1 needs to be a superuser

CThe sales schema does not exist

DUser1 lacks USAGE privilege on the sales schema

Step-by-Step Solution

Solution:

Step 1: Check required privileges for creating tables
Both CREATE and USAGE privileges are needed to create tables in a schema.
Step 2: Identify missing privilege
User1 has CREATE but likely lacks USAGE privilege, blocking table creation.
Final Answer:
User1 lacks USAGE privilege on the sales schema -> Option D
Quick Check:
Missing USAGE privilege blocks creation despite CREATE grant [OK]

Quick Trick: Both CREATE and USAGE needed to create objects [OK]

Common Mistakes:

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Consider the command: