turbot/aws_insights

Query: backup_vault_policy

Usage

powerpipe query aws_insights.query.backup_vault_policy

Steampipe Tables

SQL

select
s -> 'Action' as "Action",
s -> 'Effect' as "Effect",
s -> 'Resource' as "Resource",
s -> 'Principal' as "Principal"
from
aws_backup_vault,
jsonb_array_elements(policy_std -> 'Statement') as s
where
arn = $1
and account_id = split_part($1, ':', 5)
and region = split_part($1, ':', 4);