Business information leak - DB
Description
From sensitive information stored in the source code, business information is obtained, such as:
- Users who have made recent transactions, document number and full name.
- Wallet IDs.
- Versions and operating system names.
- Transaction codes.
- Endpoints available to, and consumed by each user.
- Associated credit cards.
- Available balance.
Impact
- Obtain information about users and their common transactions.
- Obtain information about the applications APIs, and the parameters required to query them.
- Identify the devices a user uses to access the application.
- Associate a user with an account number, credit card number, and available balance.
Recommendation
According to the classification of the found information, establish the necessary controls, so the information is accessible only to the indicated persons.
Threat
Authorized attacker with the credentials obtained from the source code, on Internet.
Expected Remediation Time
⌚ 60 minutes.
Score
Default score using CVSS 3.1. It may change depending on the context of the vulnerability.
Base
- Attack vector: N
- Attack complexity: H
- Privileges required: H
- User interaction: N
- Scope: U
- Confidentiality: H
- Integrity: L
- Availability: N
Temporal
- Exploit code madurity: X
- Remediation level: X
- Report confidence: X
Result
- Vector string: CVSS:3.1/AV:N/AC:H/PR:H/UI:N/S:U/C:H/I:L/A:N/E:X/RL:X/RC:X
- Score:
- Base: 5.0
- Temporal: 5.0
- Severity:
- Base: Medium
- Temporal: Medium
Code Examples
Compliant code
The application uses a secure method to access the db without showing credentials in the source code
function getUserInfo(isLoggedIn, user){
const connection = createSQLConnection(user.Credentials);
connection.query('SELECT * FROM employee', function (error, results, fields) {
if (error) throw error;
results.forEach(result => {
//Code to handle the results
});
});
}
Non compliant code
The source code shows the db credentials directly
let connection = mysql.createConnection({
host: 'localhost',
user: 'root',
password: '1234',
database: 'clients'
});
function getUserInfo(isLoggedIn, user){
connection.query('SELECT * FROM employee', function (error, results, fields) {
if (error) throw error;
results.forEach(result => {
//Code to handle the results
});
});
}
Requirements
- 176. Restrict system objects
- 177. Avoid caching and temporary files
- 261. Avoid exposing sensitive information
- 300. Mask sensitive data
Search for vulnerabilities in your apps for free with our automated security testing! Start your 21-day free trial and discover the benefits of our Continuous Hacking Machine Plan. If you prefer a full service that includes the expertise of our ethical hackers, don't hesitate to contact us for our Continuous Hacking Squad Plan.