Native VALID UNTIL vs External IdP for Credential Expiration
Credential Lifecycle Management Implementing a least-privilege security model in PostgreSQL often requires strict control over credential lifespans to mitigate the risk of stale accounts. There are two primary documented paths for enforcing expiration: using the native VALID UNTIL attribute within CREATE ROLE or delegating authentication to an external Ident