PostgreSQL - Roles and Security
Which password authentication method in PostgreSQL is considered more secure and recommended for use?
Which password authentication method in PostgreSQL is considered more secure and recommended for use?
easy📝 Conceptual Q11 of 15
Step-by-Step Solution
Solution:
Step 1: Understand common PostgreSQL password methods
PostgreSQL supports several password authentication methods including md5 and scram-sha-256.Step 2: Compare security levels
SCRAM-SHA-256 is a newer, more secure method than MD5, which is older and less secure.Final Answer:
scram-sha-256 -> Option AQuick Check:
More secure method = scram-sha-256 [OK]
Quick Trick: SCRAM is newer and stronger than MD5 for passwords [OK]
Common Mistakes:
- Confusing md5 as more secure than scram-sha-256
- Choosing 'password' which sends plain text
- Selecting 'trust' which requires no password
Master "Roles and Security" in PostgreSQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore PostgreSQL Quizzes