[Solved] Which command creates a group role named developers that cannot login? — Ans: CREATE ROLE developers NOLOGIN; | PostgreSQL

PostgreSQL - Roles and Security

Which command creates a group role named developers that cannot login?

ACREATE ROLE developers LOGIN;

BCREATE ROLE developers WITH LOGIN PASSWORD 'pass';

CCREATE USER developers;

DCREATE ROLE developers NOLOGIN;

Step-by-Step Solution

Solution:

Step 1: Identify the command to create a role without login
To create a group role, the NOLOGIN attribute must be specified to prevent login capability.
Step 2: Analyze each option
CREATE ROLE developers LOGIN; enables login, so it's a login role. CREATE ROLE developers NOLOGIN; correctly creates a role without login. CREATE USER developers; creates a login user by default. CREATE ROLE developers WITH LOGIN PASSWORD 'pass'; creates a login role with password.
Final Answer:
CREATE ROLE developers NOLOGIN; -> Option D
Quick Check:
Group role creation = NOLOGIN [OK]

Quick Trick: Use NOLOGIN to create group roles without login [OK]

Common Mistakes:

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Which command creates a group role named developers that cannot login?