Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Given the database schema below, and a form that asks a user to provide their account number in order to retrieve the account balance through
Given the database schema below, and a form that asks a user to provide their account number in order to retrieve the account balance through the following query, craft a SQL injection attack that would allow customer John Doe to "steal" $500 from customer Homer Simpson.
SELECT Balance
FROM Accounts
WHERE Account_Num =
a) the rationale for why you set it up the way you did
b) what the expected result(s) will be if the attack was to be carried out.
foreign keys Customer Account 123-45-6789 256101 123-45-6789 256202 987-65-4321 256304 Customers SSN Name 123-45-6789 John Doe 987-65-4321 Homer Simpson Address 4400 University Dr, Fairfax, VA 10 First St, Springfield, OH Accounts Account Num Description 256101 Checking Savings Checking 256202 256304 Balance $ 10,000 $ 12,000 $ 10,300
Step by Step Solution
There are 3 Steps involved in it
Step: 1
a Rationale for Setup The database schema is set up to contain tables for Customers and Accounts The Customers table contains personal information about each customer such as their name address and so...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started