Which of the following are countermeasures to prevent unauthorized database access attacks?
Each correct answer represents a complete solution. (Choose all that apply.)
Which of the following are countermeasures to prevent unauthorized database access attacks?
Each correct answer represents a complete solution. (Choose all that apply.)
To prevent unauthorized database access attacks, session encryption ensures that data transmitted between the client and the database is secure, applying strong firewall rules helps in controlling and monitoring the traffic to and from the database, and input sanitization prevents SQL injection attacks by validating and cleansing user inputs. Removing all stored procedures is not a practical countermeasure, as stored procedures are crucial for enforcing business logic and improving performance.
B Is a prevention
While removing stored procedures might seem like a security measure to prevent unauthorized access, it's not a comprehensive solution and can have significant drawbacks. Stored procedures serve legitimate purposes in many database applications, such as improving performance, enforcing business logic, and promoting code reusability. Removing all stored procedures could disrupt the functionality of the database and the applications relying on it.