You want to create a role 'manager' that can login, create databases, and also inherit permissions from another role 'staff'. Which commands correctly set this up?

hard📝 Application Q9 of 15

PostgreSQL - Roles and Security

ACREATE ROLE manager LOGIN CREATEDB INHERIT; GRANT staff TO manager;

BCREATE ROLE staff; CREATE ROLE manager LOGIN INHERIT CREATEDB; GRANT staff TO manager;

CCREATE ROLE manager LOGIN CREATEDB; ALTER ROLE manager INHERIT; GRANT staff TO manager;

DCREATE ROLE manager LOGIN CREATEDB; GRANT manager TO staff;

Step-by-Step Solution

Solution:

Step 1: Create base role 'staff'
First, create the 'staff' role without login.
Step 2: Create 'manager' role with LOGIN, CREATEDB, and INHERIT
CREATE ROLE staff; CREATE ROLE manager LOGIN INHERIT CREATEDB; GRANT staff TO manager; correctly creates 'manager' with these attributes.
Step 3: Grant 'staff' role to 'manager'
This allows 'manager' to inherit permissions from 'staff'.
Final Answer:
CREATE ROLE staff; CREATE ROLE manager LOGIN INHERIT CREATEDB; GRANT staff TO manager; -> Option B
Quick Check:
INHERIT + GRANT role to role = permission inheritance [OK]

Quick Trick: Use GRANT role TO role for inheritance after creating roles [OK]

Common Mistakes:

Granting roles in wrong direction
Misplacing INHERIT keyword
Trying to ALTER INHERIT separately

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

You want to create a role 'manager' that can login, create databases, and also inherit permissions from another role 'staff'. Which commands correctly set this up?

Step 1: Create base role 'staff'

Step 2: Create 'manager' role with LOGIN, CREATEDB, and INHERIT

Step 3: Grant 'staff' role to 'manager'

Final Answer:

Quick Check:

Want More Practice?