terraform.gcp.security.gcp-bigquery-private-table-iam-binding.gcp-bigquery-private-table-iam-binding

profile photo of semgrepsemgrep
Author
unknown
Download Count*
LGPL Commons Clause
License

Ensure that BigQuery Tables are not anonymously or publicly accessible

Run Locally

Run in CI

Semgrep CI docs

Defintion

Edit RuleView Source
Open in Playground 
rules:
  - id: gcp-bigquery-private-table-iam-binding
    patterns:
      - pattern: resource
      - pattern-either:
          - pattern-inside: |
              resource "google_bigquery_table_iam_binding" "..." {
              ...
              members = [ ..., "allAuthenticatedUsers", ...]
              ...
              }
          - pattern-inside: |
              resource "google_bigquery_table_iam_binding" "..." {
              ...
              members = [ ..., "allUsers", ...]
              ...
              }
    message: "Ensure that BigQuery Tables are not anonymously or publicly
      accessible\t\t"
    metadata:
      owasp:
        - A05:2017 - Broken Access Control
        - A01:2021 - Broken Access Control
      cwe:
        - "CWE-284: Improper Access Control"
      category: security
      technology:
        - terraform
        - gcp
      references:
        - https://docs.bridgecrew.io/docs/google-cloud-policy-index
      subcategory:
        - audit
      likelihood: LOW
      impact: LOW
      confidence: LOW
      license: Commons Clause License Condition v1.0[LGPL-2.1-only]
      vulnerability_class:
        - Improper Authorization
    languages:
      - hcl
    severity: WARNING

Examples

gcp-bigquery-private-table-iam-binding.tf

# ok: gcp-bigquery-private-table-iam-binding
resource "google_bigquery_table_iam_binding" "pass1" {
  cluster = "my-private-table-binding1"
  role    = "roles/bigquery.admin"
  members = [
    "user:jane@example.com",
    "group:mygroup@example.com",
  ]
}

# ok: gcp-bigquery-private-table-iam-binding
resource "google_bigquery_table_iam_binding" "pass2" {
  cluster = "my-private-table-binding2"
  role    = "roles/bigquery.connectionAdmin"
  members = [
    "user:jason@example.com",
  ]
}

# fail
# ruleid: gcp-bigquery-private-table-iam-binding
resource "google_bigquery_table_iam_binding" "fail1" {
  cluster = "my-public-table-binding1"
  role    = "roles/bigquery.dataOwner"
  members = [
    "allAuthenticatedUsers",
  ]
}

# fail
# ruleid: gcp-bigquery-private-table-iam-binding
resource "google_bigquery_table_iam_binding" "fail2" {
  cluster = "my-public-table-binding2"
  role    = "roles/bigquery.dataViewer"
  members = [
    "allUsers",
  ]
}

# fail
# ruleid: gcp-bigquery-private-table-iam-binding
resource "google_bigquery_table_iam_binding" "fail3" {
  cluster = "my-public-table-binding3"
  role    = "roles/bigquery.filteredDataViewer"
  members = [
    "allUsers",
    "user:jason@example.com",
  ]
}

# fail
# ruleid: gcp-bigquery-private-table-iam-binding
resource "google_bigquery_table_iam_binding" "fail4" {
  cluster = "my-public-table-binding4"
  role    = "roles/bigquery.jobUser"
  members = [
    "user:jason@example.com",
    "allAuthenticatedUsers",
  ]
}