---
title: "Comment by Serge Shakhov on \"Snowflake Syntax: Show Grants\" | Hashnode"
description: "Hi John, What is MONITOR_GRANT_TO_ROLES? It doesn't exist in my Snowflake databases."
url: "https://hashnode.com/posts/snowflake-syntax-show-grants/6699290a238bd0e6da03d891/comment/66b5612c2d8705f850a8cb56"
---

[Discussion](https://hashnode.com/posts/snowflake-syntax-show-grants/6699290a238bd0e6da03d891)

Comment [Snowflake Syntax: Show Grants](https://hashnode.com/posts/snowflake-syntax-show-grants/6699290a238bd0e6da03d891)

[Serge Shakhov](https://hashnode.com/@ACETYLENE)

[Aug 9, 2024](https://hashnode.com/posts/snowflake-syntax-show-grants/6699290a238bd0e6da03d891/comment/66b5612c2d8705f850a8cb56)

Hi John, What is MONITOR\_GRANT\_TO\_ROLES? It doesn't exist in my Snowflake databases.

[John Ryan](https://hashnode.com/@JohnRyan)

[Aug 15, 2024](https://hashnode.com/posts/snowflake-syntax-show-grants/6699290a238bd0e6da03d891/comment/66b5612c2d8705f850a8cb56#reply-66be0114422f318982ba47d2)

Hey Serge. Really sorry for the typo, I normally create a local temporary table to avoid re-querying the ACCOUNT\_USAGE views.

Now amended (and TESTED!) the query.

Thanks for pointing that out. Hope it's useful to you now!
