If a database cursor is not closed properly, then it could become accessible to other users while retaining the same privileges that were originally assigned, leaving the cursor "dangling."
For example, an improper dangling cursor could arise from unhandled exceptions. The impact of the issue depends on the cursor's role, but SQL injection attacks are commonly possible.
| Nature | Mapping | Type | ID | Name |
|---|---|---|---|---|
| ChildOf | Allowed-with-Review | C | 402 | Transmission of Private Resources into a New Sphere ('Resource Leak') |
| ParentOf | Allowed-with-Review | C | 404 | Improper Resource Shutdown or Release |
| Nature | Mapping | Type | ID | Name |
|---|---|---|---|---|
| MemberOf | Prohibited | C | 399 | Resource Management Errors |
| MemberOf | Prohibited | C | 990 | SFP Secondary Cluster: Tainted Input to Command |
| MemberOf | Prohibited | C | 1403 | Comprehensive Categorization: Exposed Resource |
| Nature | Mapping | Type | ID | Name |
|---|---|---|---|---|
| MemberOf | Prohibited | BS | BOSS-240 | Weaknesses in Software Written in SQL |
| MemberOf | Prohibited | BS | BOSS-272 | Weaknesses in Database Server |
| MemberOf | Prohibited | BS | BOSS-318 | Modify Application Data (impact) |
| MemberOf | Prohibited | BS | BOSS-328 | Read Application Data (impact) |
| Nature | Mapping | Type | ID | Name |
|---|---|---|---|---|
| MemberOf | Prohibited | C | 399 | Resource Management Errors |
| Nature | Mapping | Type | ID | Name |
|---|---|---|---|---|
| MemberOf | Prohibited | C | 990 | SFP Secondary Cluster: Tainted Input to Command |
A cursor is a feature in Oracle PL/SQL and other languages that provides a handle for executing and accessing the results of SQL queries.
| Scope | Likelihood | Impact | Note |
|---|---|---|---|
| ConfidentialityIntegrity | N/A | Read Application DataModify Application Data | N/A |
Close cursors immediately after access to them is complete. Ensure that you close cursors if exceptions occur.
This issue is currently reported for unhandled exceptions, but it is theoretically possible any time the programmer does not close the cursor at the proper time.
| Reference | Description |
|---|
| Ordinality | Description |
|---|---|
| Primary | This could be primary when the programmer never attempts to close the cursor when finished with it. |
| Resultant | N/A |
This CWE entry is at the Base level of abstraction, which is a preferred level of abstraction for mapping to the root causes of vulnerabilities.
Carefully read both the name and description to ensure that this mapping is an appropriate fit. Do not try to 'force' a mapping to a lower-level Base/Variant simply to comply with this preferred level of abstraction.
| Taxonomy Name | Entry ID | Fit | Entry Name |
|---|---|---|---|
| Software Fault Patterns | SFP24 | N/A | Tainted input to command |
| ID | Name |
|---|