Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Snowflake Security Dashboards - queries against Users should filter out disabled Users #1503

Open
SnowflakeJim opened this issue Aug 22, 2024 · 0 comments

Comments

@SnowflakeJim
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant