easy5 pts · first answer countssecuritysql

Database user for the app

Which database account setup is best for a production API service?

A.Use the superuser account for everything, so migrations, extensions and queries never fail on missing permissionsB.Give the app its own user with only the rights it needs on its tables, and run migrations with a separate userC.Share one admin account between all services so passwords are easier to rotateD.Grant ALL PRIVILEGES on every database to the app user

← What HTTPS leaves visible Take the easy mock interview →