When security is the top most priority. i.e. to allow unauthorized access

When backups are essential

When Maintenance is desired. Triggers can be fired when any error message is logged

Keeping the database consistent.