Cloud SQL Instance With Cross DB Ownership Chaining On

• Query id: 9e0c33ed-97f3-4ed6-8be9-bcbf3f65439f
• Query name: Cloud SQL Instance With Cross DB Ownership Chaining On
• Platform: Ansible
• Severity: High
• Category: Insecure Configurations
• URL: Github

Description

GCP SQL Instance should not have Cross DB Ownership Chaining On
Documentation

Code samples

Code samples with security vulnerabilities

Positive test num. 1 - yaml file

- name: sql_instance
  google.cloud.gcp_sql_instance:
    auth_kind: serviceaccount
    database_version: SQLSERVER_13_1
    name: "{{ resource_name }}-2"
    project: test_project
    region: us-central1
    service_account_file: /tmp/auth.pem
    settings:
      database_flags:
      - name: cross db ownership chaining
        value: on
      tier: db-n1-standard-1
    state: present

Code samples without security vulnerabilities

Negative test num. 1 - yaml file

- name: sql_instance
  google.cloud.gcp_sql_instance:
    auth_kind: serviceaccount
    database_version: SQLSERVER_13_1
    name: '{{ resource_name }}-2'
    project: test_project
    region: us-central1
    service_account_file: /tmp/auth.pem
    settings:
      database_flags:
      - name: name1
        value: value1
      tier: db-n1-standard-1
    state: present