Databases · Junior · Question 49 of 75

Why should an application connect to the database with a user that has limited privileges?

1The superuser can't connect over the network
✓Correct answer: If the app is compromised, the attacker can't drop tables or read data the app never needs
3Limited users get faster queries

Explanation

Grant only the needed rights (GRANT SELECT, INSERT ON ...). Run migrations with a separate, more powerful role.

Further reading

Test yourself

Take the Databases · Junior quiz: questions and options are shuffled, and you get a review of your mistakes at the end.