Snowflake-Labs
Snowflake Security Dashboards - queries against Users should filter out disabled Users
Describe the bug In the Snowflake Security Dashboards there are multiple queries that hit the USERS view to present things like stale users, oldest password, most dangerous person, etc.
All of these queries should include a clause to filter out disabled records:
AND DISABLED = FALSE
Otherwise the results will present inactive accounts as being active security concerns.
URL of where you see the bug https://quickstarts.snowflake.com/guide/security_dashboards_for_snowflake/index.html?index=..%2F..index#0
To Reproduce N/A
Expected behavior Disabled Users should not be included in query results as they don't represent active security concerns/risks
Screenshots N/A
Desktop (please complete the following information): N/A
Smartphone (please complete the following information): N/A
Additional context N/A
