Cloud SQL for MySQL allows all users to see database names Affecting Cloud SQL service in Google


Severity

0.0
low
0
10
Severity Framework
Snyk CCSS
Rule category
Data/ Access

Is your environment affected by this misconfiguration?

In a few clicks we can analyze your entire application and see what components are vulnerable in your application, and suggest you quick fixes.

Test your applications
Frameworks
  • Snyk IDSNYK-CC-00362
  • creditSnyk Research Team

Description

Users might be able to see database names without having been explicitly authorized to access them.

How to fix?

Set a settings.database_flags block, with name as skip_show_database and value as on.

Example Configuration

resource "google_sql_database_instance" "allowed" {
   name             = "allowed-instance"
   database_version = "MYSQL_8_0"
   region           = "us-central1"

   settings {
     tier = "db-f1-micro"

     database_flags {
       name = "skip_show_database"
       value = "on"
     }

     database_flags {
       name = "performance_schema"
       value = "off"
     }
   }
}