[Solved] In PostgreSQL, what does the command CREATE ROLE manager; do by default? — Ans: Creates a role without login permission | PostgreSQL

PostgreSQL - Roles and Security

In PostgreSQL, what does the command CREATE ROLE manager; do by default?

ACreates a role without login permission

BCreates a role with login permission

CCreates a user with a password

DCreates a database named 'manager'

Step-by-Step Solution

Solution:

Step 1: Understand default behavior of CREATE ROLE
By default, roles created with CREATE ROLE do not have login permission unless specified.
Step 2: Analyze the command given
The command CREATE ROLE manager; creates a role named 'manager' without login permission.
Final Answer:
Creates a role without login permission -> Option A
Quick Check:
Default CREATE ROLE = no login permission [OK]

Quick Trick: Roles need LOGIN explicitly to allow user access [OK]

Common Mistakes:

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

In PostgreSQL, what does the command CREATE ROLE manager; do by default?