2.5 Ensure monitoring and alerting exist for creation, update and deletion of security integrations

Information

Security integration object is used to configure SSO and SCIM integrations.

Creation of an unauthorized security integration, in case of SCIM, can lead to creation of rogue Snowflake users. Incase of SSO, it can lead to hijacking of existing Snowflake users through rogue authentication flow.

Update or deletion of an existing security integration can lead to weakening security posture of that integration or denial of service, e.g. when users cannot sign into Snowflake accounts due to broken SSO authentication flow.

NOTE: Nessus has not performed this check. Please review the benchmark to ensure target compliance.

Solution

Programmatically:

In a Snowsight worksheet or through the SnowSQL CLI:

-

Configure your security monitoring solution to alert on creation, update and deletion of security integrations.

select end_time, query_type, query_text, user_name, role_namefrom snowflake.account_usage.query_historywhere execution_status = 'SUCCESS' and query_type in ('CREATE', 'ALTER', 'DROP') and query_text ilike '%security integration%'order by end_time desc;

Impact:

If security integration creation, update and deletion events happen frequently, monitoring and alerting on this event may generate undue load on the detection and response team.

See Also

https://workbench.cisecurity.org/benchmarks/14781

Item Details

Category: AUDIT AND ACCOUNTABILITY

References: 800-53|AU-6, 800-53|AU-6(1), 800-53|AU-7(1), CSCv7|6.7

Plugin: Snowflake

Control ID: 47ec3e2c7bc6371e3e66ee6e9055e81da08b0fe692542240adf9790db2a52e72