[Solved] Which of the following is the correct syntax to create a login role named bob with password secret? — Ans: CREATE ROLE bob WITH LOGIN PASSWORD 'secret'; | PostgreSQL

PostgreSQL - Roles and Security

Which of the following is the correct syntax to create a login role named bob with password secret?

ACREATE ROLE bob LOGIN PASSWORD secret;

BCREATE ROLE bob WITH LOGIN PASSWORD 'secret';

CCREATE ROLE bob PASSWORD secret LOGIN;

DCREATE ROLE bob WITH PASSWORD secret LOGIN;

Step-by-Step Solution

Solution:

Step 1: Recall correct syntax for creating login role with password
The correct syntax uses WITH keyword before LOGIN and PASSWORD clauses.
Step 2: Evaluate each option
CREATE ROLE bob WITH LOGIN PASSWORD 'secret'; uses 'WITH LOGIN PASSWORD' correctly. Options A and B miss the WITH keyword or have wrong order. CREATE ROLE bob WITH PASSWORD 'secret' LOGIN; misplaces keywords.
Final Answer:
CREATE ROLE bob WITH LOGIN PASSWORD 'secret'; -> Option B
Quick Check:
Correct syntax includes WITH LOGIN PASSWORD [OK]

Quick Trick: Use WITH before LOGIN and PASSWORD in CREATE ROLE [OK]

Common Mistakes:

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Which of the following is the correct syntax to create a login role named bob with password secret?