Design short-lived dynamic database credentials and their security benefits

WHAT THIS TESTS: This question evaluates whether you can replace dangerous long-lived database passwords with an automated, identity-driven credential lifecycle. Interviewers want to see that you understand lease-based secret management, workload authentication, and the operational trade-offs of dynamic credentials in production pipelines.

A GOOD ANSWER COVERS: A strong design starts with a secrets broker such as HashiCorp Vault or a cloud provider secret manager that supports database plugins. The broker authenticates the workload using identity, for example via Kubernetes service account JWT, AWS IAM, or mTLS client certificates. Upon authentication, the broker creates a temporary database user with a narrowly scoped role, for instance read-only on a specific schema, and returns a lease with a short TTL such as five to fifteen minutes. The application or CI job uses the credential until the job finishes or the TTL expires, at which point the broker automatically revokes the user and flushes connections. Security benefits include eliminating static secrets from source control and CI variables, reducing blast radius because leaked credentials expire quickly, enforcing least privilege per workload, and creating an audit trail of every credential creation and access event.

COMMON WRONG ANSWERS: Red flags include proposing a cron job that rotates a single shared password and updates an environment variable, which still leaves a window of exposure and does not isolate workloads. Another anti-pattern is storing a static master password in a secrets manager and calling it dynamic; the interviewer is listening for lease semantics and automatic revocation. Ignoring connection pooling is also a mistake, because abruptly dropping a user can break pooled connections, so you should mention graceful revocation or max connection age settings.

LIKELY FOLLOW-UPS: The interviewer may ask how you handle credential renewal for long-running jobs without dropping connections, how you protect the secrets broker itself from becoming a single point of compromise, or how you rotate the broker's own root database credentials. They might also probe the performance impact of creating many ephemeral users on the database, or ask how you manage schema migration jobs that need elevated privileges temporarily.

ONE CONCRETE EXAMPLE: Imagine a GitHub Actions workflow that runs integration tests against a Postgres instance. The workflow authenticates to the secrets broker using an OIDC token. The broker provisions a temporary Postgres role that owns only the test schema and returns a username and password valid for ten minutes. The test suite connects via a standard driver, runs tests, and exits. The lease expires and the broker drops the user. If the OIDC token were compromised, the attacker could only obtain credentials scoped to the test database, and those credentials would expire within minutes.