You want to create a group role editors and assign two login roles carol and dave to it. Which sequence is correct?

hard📝 Application Q8 of 15

PostgreSQL - Roles and Security

You want to create a group role editors and assign two login roles carol and dave to it. Which sequence is correct?

ACREATE ROLE editors NOLOGIN; CREATE ROLE carol LOGIN; CREATE ROLE dave LOGIN; GRANT carol, dave TO editors;

BCREATE ROLE editors LOGIN; CREATE ROLE carol NOLOGIN; CREATE ROLE dave NOLOGIN; GRANT editors TO carol, dave;

CCREATE ROLE editors NOLOGIN; CREATE ROLE carol LOGIN; CREATE ROLE dave LOGIN; GRANT editors TO carol, dave;

DCREATE ROLE editors NOLOGIN; CREATE ROLE carol LOGIN; CREATE ROLE dave LOGIN; GRANT carol TO editors; GRANT dave TO editors;

Step-by-Step Solution

Solution:

Step 1: Create group role without LOGIN
Group roles should have NOLOGIN attribute.
Step 2: Create login roles for users
Carol and Dave must have LOGIN attribute to connect.
Step 3: Grant group role to users
Granting editors to carol and dave assigns group privileges to them.
Final Answer:
CREATE ROLE editors NOLOGIN; CREATE ROLE carol LOGIN; CREATE ROLE dave LOGIN; GRANT editors TO carol, dave; -> Option C
Quick Check:
Group role NOLOGIN, users LOGIN, grant group to users [OK]

Quick Trick: Grant group role to login roles, not vice versa [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