Which of the following is the correct syntax to grant CREATE privilege on a schema named sales to user alice?

easy📝 Syntax Q12 of 15

PostgreSQL - Roles and Security

Which of the following is the correct syntax to grant CREATE privilege on a schema named sales to user alice?

AGRANT CREATE ON sales TO alice;

BGRANT CREATE TO alice ON SCHEMA sales;

CGRANT CREATE ON SCHEMA sales TO alice;

DGRANT CREATE ON DATABASE sales TO alice;

Step-by-Step Solution

Solution:

Step 1: Identify correct GRANT syntax for schema
In PostgreSQL, to grant privileges on a schema, the syntax is: GRANT privilege ON SCHEMA schema_name TO user;
Step 2: Match syntax with options
GRANT CREATE ON SCHEMA sales TO alice; matches this syntax exactly: GRANT CREATE ON SCHEMA sales TO alice;
Final Answer:
GRANT CREATE ON SCHEMA sales TO alice; -> Option C
Quick Check:
GRANT ... ON SCHEMA ... TO ... [OK]

Quick Trick: Use 'ON SCHEMA' when granting schema privileges [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