[Solved] What is wrong with this command?ALTER ROLE readonly CREATEDB NOLOGIN; — Ans: No error, command is valid | PostgreSQL

PostgreSQL - Roles and Security

What is wrong with this command?

ALTER ROLE readonly CREATEDB NOLOGIN;

ANo error, command is valid

BNOLOGIN cannot be set with CREATEDB

CALTER ROLE requires multiple commands for multiple attributes

DAttributes must be separated by commas

Step-by-Step Solution

Solution:

Step 1: Understand ALTER ROLE attribute syntax
Multiple attributes can be set in one ALTER ROLE command separated by spaces.
Step 2: Check if CREATEDB and NOLOGIN can coexist
They can be set together; no syntax error.
Final Answer:
No error, command is valid -> Option A
Quick Check:
ALTER ROLE accepts multiple attributes space-separated [OK]

Quick Trick: ALTER ROLE attributes are space-separated, no commas needed [OK]

Common Mistakes:

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What is wrong with this command?