SQL Server Interview Question #183
What is the principle of least privilege?
Security, Backup, Recovery, Administration & Real-World Scenarios Senior Advanced
Detailed Explanation
Least privilege means giving an account only the permissions required to perform its intended responsibilities, and no more.
For example, a reporting application that only reads selected tables should not normally receive db_owner or sysadmin privileges. Least privilege reduces the potential impact of compromised credentials, programming errors, and accidental administrative actions.