4.10 Ensure all accounts that can log in have passwords

Information

If users with database accounts that have the ability to login do not have a password set then anyone can masquerade as these users.

All accounts that can login to the database should challenge the user for an account password.

Solution

Set a valid password for any database user identified above.

postgres=# \\password user1

This shows setting the password for user1 . You can user ALTER ROLE, but note that the passwords will be emitted to the PostgreSQL logs.

See Also

https://workbench.cisecurity.org/benchmarks/24764

Item Details

Category: IDENTIFICATION AND AUTHENTICATION

References: 800-53|IA-5(1), CSCv7|4.4

Plugin: PostgreSQLDB

Control ID: daaab643489affdec95c8ed87cbf3b7df3a6b56d4a12e73173b5f37d339c6289