[Solved] What will be the result of this command sequence?CREATE ROLE interns NOLOGIN; CREATE ROLE emma NOLOGIN; GRANT interns TO emma; SELECT rolcanlogin FROM pg_roles WHERE rolname = 'emma'; | PostgreSQL

PostgreSQL - Roles and Security

What will be the result of this command sequence?

CREATE ROLE interns NOLOGIN;
CREATE ROLE emma NOLOGIN;
GRANT interns TO emma;
SELECT rolcanlogin FROM pg_roles WHERE rolname = 'emma';

Atrue

Bfalse

CNULL

DError: role does not exist

Step-by-Step Solution

Solution:

Step 1: Check login attribute of emma
Emma is created with NOLOGIN, so rolcanlogin is false.
Step 2: Understand role membership effect
Granting interns to emma does not change emma's login ability.
Final Answer:
false -> Option B
Quick Check:
NOLOGIN role returns rolcanlogin = false [OK]

Quick Trick: NOLOGIN roles have rolcanlogin = false in pg_roles [OK]

Common Mistakes:

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What will be the result of this command sequence?