CAS-002 · Question #854
A security tester is testing a website and performs the following manual query: The following response is received in the payload: "ORA-000001: SQL command not properly ended" Which of the following…
The correct answer is A. Fingerprinting. Receiving an Oracle-specific error message in response to a crafted query is an example of fingerprinting, as it discloses the underlying database technology to the attacker.
Question
A security tester is testing a website and performs the following manual query:
The following response is received in the payload:
"ORA-000001: SQL command not properly ended" Which of the following is the response an example of?
Options
- AFingerprinting
- BCross-site scripting
- CSQL injection
- DPrivilege escalation
How the community answered
(34 responses)- A88% (30)
- B3% (1)
- C3% (1)
- D6% (2)
Why each option
Receiving an Oracle-specific error message in response to a crafted query is an example of fingerprinting, as it discloses the underlying database technology to the attacker.
Fingerprinting is the reconnaissance technique of identifying the type and version of software running on a target system. The error message 'ORA-000001: SQL command not properly ended' is Oracle-specific syntax, revealing to the tester that the backend database is Oracle - this is valuable target intelligence even though no data was extracted or modified.
Cross-site scripting involves injecting malicious JavaScript into a web page to execute in another user's browser, which has no relation to submitting a database query and receiving a vendor-specific error response.
SQL injection is the attack vector used to craft and submit the query, but the error response itself is evidence of fingerprinting - the question asks what the response is an example of, not what technique was used.
Privilege escalation involves obtaining higher access rights than originally authorized within a system, and is not demonstrated by receiving a database syntax error message.
Concept tested: Database fingerprinting via verbose error message disclosure
Source: https://owasp.org/www-project-web-security-testing-guide/latest/4-Web_Application_Security_Testing/01-Information_Gathering/02-Fingerprint_Web_Server
Topics
Community Discussion
No community discussion yet for this question.