More Info:

Ensures SQL instances root user cannot be accessed from any host. Root access for SQL instance should only be allowed from whitelisted IPs to ensure secure access only from trusted entities.

Risk Level

Critical

Address

Security

Compliance Standards

CISGCP, CBP, HITRUST, SOC2, NISTCSF, PCIDSS

Triage and Remediation

Remediation

To remediate the misconfiguration “Root User Should Not Be Accessible From Any Host” for GCP using GCP console, follow these steps:

  1. Login to the GCP console at https://console.cloud.google.com/
  2. Navigate to the IAM & Admin section on the left-hand side of the console.
  3. Click on the “IAM” tab.
  4. Search for the “root” user in the list of IAM users.
  5. Click on the edit icon (pencil) next to the root user.
  6. In the “Add a member” field, enter the email address of the user you want to grant root user access to.
  7. Select the “Project” role from the dropdown menu.
  8. Click the “Save” button.

Once you have completed these steps, the root user will no longer be accessible from any host. Only the new user that you granted root user access to will be able to access the root user privileges.

Additional Reading: