[Solved] Which PostgreSQL command grants a user the ability to create objects in a schema named 'inventory'? — Ans: GRANT CREATE ON SCHEMA inventory TO username; | PostgreSQL

PostgreSQL - Roles and Security

Which PostgreSQL command grants a user the ability to create objects in a schema named 'inventory'?

AGRANT USAGE ON SCHEMA inventory TO username;

BGRANT ALL PRIVILEGES ON SCHEMA inventory TO username;

CGRANT SELECT ON SCHEMA inventory TO username;

DGRANT CREATE ON SCHEMA inventory TO username;

Step-by-Step Solution

Solution:

Step 1: Identify the privileges needed for object creation
CREATE privilege allows creating objects in a schema; USAGE allows access to the schema.
Step 2: Match the correct GRANT syntax
GRANT CREATE ON SCHEMA inventory TO username; grants the ability to create objects.
Final Answer:
GRANT CREATE ON SCHEMA inventory TO username; -> Option D
Quick Check:
CREATE privilege allows object creation [OK]

Quick Trick: CREATE privilege allows object creation [OK]

Common Mistakes:

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Which PostgreSQL command grants a user the ability to create objects in a schema named 'inventory'?