turbot/gcp_compliance

Query: sql_instance_mysql_local_infile_database_flag_off

Usage

powerpipe query gcp_compliance.query.sql_instance_mysql_local_infile_database_flag_off

SQL

select
self_link resource,
case
when database_version not like 'MYSQL%' then 'skip'
when database_flags @> '[{"name":"local_infile","value":"off"}]' then 'ok'
else 'alarm'
end as status,
case
when database_version not like 'MYSQL%'
then title || ' not a MySQL database.'
when database_flags is null or not (database_flags @> '[{"name":"local_infile"}]')
then title || ' ''local_infile'' database flag not set.'
when database_flags @> '[{"name":"local_infile","value":"off"}]'
then title || ' ''local_infile'' database flag set to ''off''.'
else title || ' ''local_infile'' database flag set to ''on''.'
end as reason
, location as location, project as project
from
gcp_sql_database_instance;

Controls

The query is being used by the following controls: