turbot/steampipe-mod-gcp-compliance

Control: Ensure API keys are restricted to use by only specified Hosts and Apps

Description

Unrestricted keys are insecure because they can be viewed publicly, such as from within a browser, or they can be accessed on a device where the key resides. It is recommended to restrict API key usage to trusted hosts, HTTP referrers and apps.

Usage

Run the control in your terminal:

powerpipe control run gcp_compliance.control.iam_api_key_restricts_websites_hosts_apps

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run gcp_compliance.control.iam_api_key_restricts_websites_hosts_apps --share

SQL

This control uses a named query:

select
'https://iam.googleapis.com/v1/projects/' || project || '/apikeys/' || name as resource,
case
when restrictions -> 'serverKeyRestrictions' is null
and restrictions -> 'browserKeyRestrictions' is null
and restrictions -> 'androidKeyRestrictions' is null
and restrictions -> 'iosKeyRestrictions' is null then 'alarm'
when restrictions -> 'serverKeyRestrictions' @> any( array[
'{"allowedIps": ["0.0.0.0"]}', '{"allowedIps": ["0.0.0.0/0"]}', '{"allowedIps": ["::0"]}']::jsonb[]) then 'alarm'
when restrictions -> 'browserKeyRestrictions' @> any( array[
'{"allowedReferrers": ["*"]}','{"allowedReferrers": ["*.[TLD]/*"]}','{"allowedReferrers": ["*.[TLD]"]}' ]::jsonb[] ) then 'alarm'
else 'ok'
end as status,
case
when restrictions -> 'serverKeyRestrictions' is null
and restrictions -> 'browserKeyRestrictions' is null
and restrictions -> 'androidKeyRestrictions' is null
and restrictions -> 'iosKeyRestrictions' is null
then title || ' API key not restricted to use any specified Websites, Hosts and Apps.'
when restrictions -> 'serverKeyRestrictions' @> any( array[
'{"allowedIps": ["0.0.0.0"]}', '{"allowedIps": ["0.0.0.0/0"]}', '{"allowedIps": ["::0"]}']::jsonb[]) then title || ' API key open to any hosts.'
when restrictions -> 'browserKeyRestrictions' @> any( array[
'{"allowedReferrers": ["*"]}','{"allowedReferrers": ["*.[TLD]/*"]}','{"allowedReferrers": ["*.[TLD]"]}' ]::jsonb[] ) then title || ' API key open to any or wide range of HTTP referrer(s).'
else title || ' API key is restricted with specific Website(s), Host(s) and App(s).'
end as reason
, location as location, project as project
from
gcp_apikeys_key;

Tags