Check your Amazon EC2 security groups for inbound rules that allow unrestricted access (i.e. 0.0.0.0/0 or ::/0) on TCP port 1521 in order to reduce the attack surface and protect the Oracle database instances associated with your security groups. TCP port 1521 is used by the Oracle Database (Oracle RDBMS), a multi-model database management system developed and marketed by Oracle Corporation.
This rule can help you with the following compliance standards:
- PCI
- APRA
- MAS
- NIST4
For further details on compliance standards supported by Conformity, see here.
This rule can help you work with the AWS Well-Architected Framework.
This rule resolution is part of the Conformity Security & Compliance tool for AWS.
Allowing unrestricted ingress/inbound access on TCP port 1521 through EC2 security group rules can increase opportunities for malicious activities such as denial-of-service (DoS) attacks, brute-force and Man-in-the-Middle (MITM) attacks, and can ultimately lead to data loss. Amazon EC2 security groups should be configured so that access to specific instances is restricted to just those hosts or networks that have a legitimate business requirement for access.
Audit
To determine if your Amazon EC2 security groups allow unrestricted Oracle database access, perform the following actions:
Remediation / Resolution
To update the inbound rule configuration for your Amazon EC2 security groups in order to restrict Oracle Database Server access to trusted entities only (i.e. authorized IP addresses and IP ranges, or other security groups), perform the following actions:
References
- AWS Documentation
- Amazon EC2 security groups for Linux instances
- Work with security groups
- Security group rules for different use cases
- Authorize inbound traffic for your Linux instances
- AWS Command Line Interface (CLI) Documentation
- ec2
- describe-security-groups
- revoke-security-group-ingress
- authorize-security-group-ingress