🧠 Azure Virtual Machine allows public access to Oracle DBMS ports - prod.logic.yaml 🟢
- Contextual name: 🧠 prod.logic.yaml 🟢
- ID:
/ce/ca/azure/virtual-machine/allows-unrestricted-traffic-to-oracle-dbms/prod.logic.yaml - Located in: 📝 Azure Virtual Machine allows public access to Oracle DBMS ports 🟢
Flags
Input Type
| Type | API Name | Extracts | Extract Files | Logic Files | |
|---|---|---|---|---|---|
| 🔒 | 📕 Azure Virtual Machine | CA10__CaAzureVirtualMachine__c | 10 | 2 | 22 |
Uses
Test Results 🟢
Generated at: 2025-06-11T14:15:04.332829532Z Open
| Result | Id | Condition Index | Condition Text | Runtime Error |
|---|---|---|---|---|
| 🟢 | test-0 | ✔️ 99 | ✔️ isDisappeared(CA10__disappearanceTime__c) | ✔️ null |
| 🟢 | test-1 | ✔️ 200 | ✔️ otherwise | ✔️ null |
| 🟢 | test-2 | ✔️ 200 | ✔️ otherwise | ✔️ null |
| 🟢 | test-3 | ✔️ 200 | ✔️ otherwise | ✔️ null |
| 🟢 | test-4 | ✔️ 200 | ✔️ otherwise | ✔️ null |
| 🟢 | test-5 | ✔️ 199 | ✔️ CA10__Azure_Network_Interfaces__r.has(INCOMPLIANT) | ✔️ null |
| 🟢 | test-6 | ✔️ 199 | ✔️ CA10__Azure_Network_Interfaces__r.has(INCOMPLIANT) | ✔️ null |
| 🟢 | test-7 | ✔️ 200 | ✔️ otherwise | ✔️ null |
Generation
| File | MD5 | |
|---|---|---|
| Open | /ce/ca/azure/virtual-machine/allows-unrestricted-traffic-to-oracle-dbms/policy.yaml | C58FA2EE80456042582A405F83C74C87 |
| Open | /ce/ca/azure/virtual-machine/allows-unrestricted-traffic-to-oracle-dbms/prod.logic.yaml | 98013039B920D62CFFE673FA135B2AEA |
| Open | /ce/ca/azure/virtual-machine/allows-unrestricted-traffic-to-oracle-dbms/test-data.json | FF7293CBAE51E2C8D234F5EB77D8367F |
| Open | /types/CA10__CaAzureNetworkSecurityGroupRule__c/object.extracts.yaml | A60C817EFBC8F066D6D082898E8597BC |
Generate FULL script
java -jar repo-manager.jar policies generate FULL /ce/ca/azure/virtual-machine/allows-unrestricted-traffic-to-oracle-dbms/prod.logic.yaml
Generate DEBUG script
java -jar repo-manager.jar policies generate DEBUG /ce/ca/azure/virtual-machine/allows-unrestricted-traffic-to-oracle-dbms/prod.logic.yaml
Generate CAPTURE_TEST_DATA script
java -jar repo-manager.jar policies generate CAPTURE_TEST_DATA /ce/ca/azure/virtual-machine/allows-unrestricted-traffic-to-oracle-dbms/prod.logic.yaml
Generate TESTS script
java -jar repo-manager.jar policies generate TESTS /ce/ca/azure/virtual-machine/allows-unrestricted-traffic-to-oracle-dbms/prod.logic.yaml
Execute tests
java -jar repo-manager.jar policies test /ce/ca/azure/virtual-machine/allows-unrestricted-traffic-to-oracle-dbms/prod.logic.yaml
Content
---
inputType: "CA10__CaAzureVirtualMachine__c"
testData:
- file: test-data.json
conditions:
- status: "INCOMPLIANT"
currentStateMessage: "The Virtual Machine has a Network Interface with a NSG that allows Oracle DBMS access from the Internet."
remediationMessage: "Restrict inbound Oracle DBMS access from the Internet."
check:
RELATED_LIST_HAS:
status: "INCOMPLIANT"
relationshipName: "CA10__Azure_Network_Interfaces__r"
otherwise:
status: "COMPLIANT"
currentStateMessage: "The Virtual Machine doesn't allow Oracle DBMS access from the Internet."
relatedLists:
- relationshipName: "CA10__Azure_Network_Interfaces__r"
importExtracts:
- file: "/types/CA10__CaAzureNetworkSecurityGroupRule__c/object.extracts.yaml"
conditions:
- status: "INCOMPLIANT"
currentStateMessage: "Network Interface with publicly accessible Network Security Group"
check:
RELATED_LIST_HAS:
status: "INCOMPLIANT"
relationshipName: "CA10__networkSecurityGroup__r.CA10__Azure_Network_Security_Group_Rules__r"
otherwise:
status: "COMPLIANT"
currentStateMessage: "Network Interface is not publicly accessible"
relatedLists:
- relationshipName: "CA10__networkSecurityGroup__r.CA10__Azure_Network_Security_Group_Rules__r"
importExtracts:
- file: "/types/CA10__CaAzureNetworkSecurityGroupRule__c/object.extracts.yaml"
conditions:
# sort public group rules
- status: "INAPPLICABLE"
currentStateMessage: "NSG Outbound Rule."
check:
NOT_EQUAL:
left:
EXTRACT: "CA10__direction__c"
right:
TEXT: "Inbound"
- status: "INAPPLICABLE"
currentStateMessage: "NSG Deny Rule."
check:
NOT_EQUAL:
left:
EXTRACT: "CA10__access__c"
right:
TEXT: "Allow"
- status: "INAPPLICABLE"
currentStateMessage: "NSG Rule with the port other than TCP or Any."
check:
NOT:
arg:
OR:
args:
- IS_EQUAL:
left:
EXTRACT: "CA10__protocol__c"
right:
TEXT: "Tcp"
- IS_EQUAL:
left:
EXTRACT: "CA10__protocol__c"
right:
TEXT: "*"
- IS_EQUAL:
left:
EXTRACT: "CA10__protocol__c"
right:
TEXT: "null"
- status: "INAPPLICABLE"
currentStateMessage: "NSG Rule source is not any address."
check:
NOT:
arg:
OR:
args:
- IS_EQUAL:
left:
EXTRACT: "CA10__sourceAddressPrefix__c"
right:
TEXT: "Internet"
- IS_EQUAL:
left:
EXTRACT: "CA10__sourceAddressPrefix__c"
right:
TEXT: "*"
- IS_EQUAL:
left:
EXTRACT: "CA10__sourceAddressPrefix__c"
right:
TEXT: "0.0.0.0"
- IS_EQUAL:
left:
EXTRACT: "CA10__sourceAddressPrefix__c"
right:
TEXT: "Any"
- CONTAINS:
arg:
EXTRACT: "CA10__sourceAddressPrefix__c"
substring:
TEXT: "/0"
# ports 1521, 1830, 2483 and 2484
- status: "INCOMPLIANT"
currentStateMessage: "NSG Rule with Oracle DBMS port 1521 with public access from the Internet."
remediationMessage: "Restrict access to the Oracle DBMS port"
check:
OR:
args:
- IS_EQUAL:
left:
EXTRACT: "CA10__destinationPortRange__c"
right:
TEXT: "1521"
- AND:
args:
- LESS_THAN_EQUAL:
left:
EXTRACT: "CA10__destinationPortFrom__c"
right:
NUMBER: 1521.0
- GREATER_THAN_EQUAL:
left:
EXTRACT: "CA10__destinationPortTo__c"
right:
NUMBER: 1521.0
- status: "INCOMPLIANT"
currentStateMessage: "NSG Rule with Oracle DBMS port 1830 with public access from the Internet."
remediationMessage: "Restrict access to the Oracle DBMS port"
check:
OR:
args:
- IS_EQUAL:
left:
EXTRACT: "CA10__destinationPortRange__c"
right:
TEXT: "1830"
- AND:
args:
- LESS_THAN_EQUAL:
left:
EXTRACT: "CA10__destinationPortFrom__c"
right:
NUMBER: 1830.0
- GREATER_THAN_EQUAL:
left:
EXTRACT: "CA10__destinationPortTo__c"
right:
NUMBER: 1830.0
- status: "INCOMPLIANT"
currentStateMessage: "NSG Rule with Oracle DBMS port 2483 with public access from the Internet."
remediationMessage: "Restrict access to the Oracle DBMS port"
check:
OR:
args:
- IS_EQUAL:
left:
EXTRACT: "CA10__destinationPortRange__c"
right:
TEXT: "2483"
- AND:
args:
- LESS_THAN_EQUAL:
left:
EXTRACT: "CA10__destinationPortFrom__c"
right:
NUMBER: 2483.0
- GREATER_THAN_EQUAL:
left:
EXTRACT: "CA10__destinationPortTo__c"
right:
NUMBER: 2483.0
- status: "INCOMPLIANT"
currentStateMessage: "NSG Rule with Oracle DBMS port 2484 with public access from the Internet."
remediationMessage: "Restrict access to the Oracle DBMS port"
check:
OR:
args:
- IS_EQUAL:
left:
EXTRACT: "CA10__destinationPortRange__c"
right:
TEXT: "2484"
- AND:
args:
- LESS_THAN_EQUAL:
left:
EXTRACT: "CA10__destinationPortFrom__c"
right:
NUMBER: 2484.0
- GREATER_THAN_EQUAL:
left:
EXTRACT: "CA10__destinationPortTo__c"
right:
NUMBER: 2484.0
otherwise:
status: "COMPLIANT"
currentStateMessage: "NSG rule without public access on Oracle DBMS port"