PostgreSQL - Roles and Security
Which PostgreSQL password authentication method stores passwords in a hashed format using SHA-256?
Which PostgreSQL password authentication method stores passwords in a hashed format using SHA-256?
easy📝 Conceptual Q1 of 15
Step-by-Step Solution
Solution:
Step 1: Understand password storage methods in PostgreSQL
PostgreSQL supports several password authentication methods, including plain text, MD5, and SCRAM-SHA-256.Step 2: Identify which method uses SHA-256 hashing
SCRAM-SHA-256 uses SHA-256 hashing for storing passwords securely, unlike MD5 which uses MD5 hashing.Final Answer:
scram-sha-256 -> Option BQuick Check:
Password hashing method = scram-sha-256 [OK]
Quick Trick: SCRAM uses SHA-256 hashing, more secure than MD5 [OK]
Common Mistakes:
- Confusing md5 with scram-sha-256
- Thinking 'password' stores hashed passwords
- Assuming 'trust' is a password method
Master "Roles and Security" in PostgreSQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore PostgreSQL Quizzes