Query: Ensure that there are only GCP-managed service account keys for each service account

Description

User managed service accounts should not have user-managed keys.

Query

Tables used in this query:

• gcp_service_account
• gcp_service_account_key

Controls using this query:

• 1.4 Ensure that there are only GCP-managed service account keys for each service account
• 1.4 Ensure that there are only GCP-managed service account keys for each service account
• 1.4 Ensure that there are only GCP-managed service account keys for each service account
• 1.4 Ensure That There Are Only GCP-Managed Service Account Keys for Each Service Account
• Ensure that there are only GCP-managed service account keys for each service account

SQL