[Solved] Identify the error in this SQL snippet:CREATE ROLE developers; CREATE ROLE bob LOGIN; GRANT developers TO bob NOLOGIN; | PostgreSQL

PostgreSQL - Roles and Security

Identify the error in this SQL snippet:

CREATE ROLE developers;
CREATE ROLE bob LOGIN;
GRANT developers TO bob NOLOGIN;

ACREATE ROLE bob LOGIN is invalid syntax.

BCREATE ROLE developers must include LOGIN.

CBob cannot be granted a role.

DThe GRANT statement incorrectly uses NOLOGIN.

Step-by-Step Solution

Solution:

Step 1: Review GRANT syntax
GRANT role TO user does not accept NOLOGIN; NOLOGIN is for CREATE ROLE only.
Step 2: Check other statements
CREATE ROLE developers is valid as group role; CREATE ROLE bob LOGIN is valid.
Final Answer:
The GRANT statement incorrectly uses NOLOGIN. -> Option D
Quick Check:
NOLOGIN only in CREATE ROLE, not GRANT [OK]

Quick Trick: NOLOGIN is for CREATE ROLE, not GRANT [OK]

Common Mistakes:

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Identify the error in this SQL snippet: