Query: S3 public access should be blocked at account and bucket levels

Description

Manage access to resources in the AWS Cloud by ensuring that AWS Simple Storage Service (AWS S3) buckets cannot be publicly accessed.

Query

Tables used in this query:

• aws_s3_account_settings
• aws_s3_bucket

Controls using this query:

• 1.20 Ensure that S3 Buckets are configured with 'Block public access (bucket settings)'
• 2.1.4 Ensure that S3 Buckets are configured with 'Block public access (bucket settings)'
• 2.1.4 Ensure that S3 Buckets are configured with 'Block public access (bucket settings)'
• 2.1.4 Ensure that S3 is configured with 'Block Public Access' enabled
• 2.1.4 Ensure that S3 is configured with 'Block Public Access' enabled
• 2.1.5 Ensure that S3 Buckets are configured with 'Block public access (bucket settings)'
• 2.1.5 Ensure that S3 Buckets are configured with 'Block public access (bucket settings)'
• 3.1.4 Ensure that S3 is configured with 'Block Public Access' enabled
• S3 public access should be blocked at account and bucket levels

SQL