---
title: "Discussion on \"Snowflake Syntax: Show Grants\" | Hashnode"
description: "Discussion on \"Snowflake Syntax: Show Grants\". Syntax on using Snowflake's SHOW GRANTS to manage and view user roles and privileges effectively"
url: "https://hashnode.com/posts/snowflake-syntax-show-grants/6699290a238bd0e6da03d891"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Snowflake Syntax: Show Grants](https://articles.analytics.today/snowflake-syntax-show-grants?utm_source=hashnode&utm_medium=feed)

Syntax on using Snowflake's SHOW GRANTS to manage and view user roles and privileges effectively

Jul 18, 2024 · 4 min read · articles.analytics.today  
Updated Jun 13, 2025  
Read the article

-   [#snowflake](https://hashnode.com/tag/snowflake)
-   [#snowflake-syntax](https://hashnode.com/tag/snowflake-syntax)

## Written by

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

@JohnRyan · UK

  
[View profile](https://hashnode.com/@JohnRyan)

Drawing Pictures, Telling Stories, Explaining Stuff

After 30 years of experience building multi-terabyte data warehouse systems, I spent five years at Snowflake as a Senior Solution Architect, helping customers across Europe and the Middle East deliver lightning-fast insights from their data. In 2023, he joined Altimate.AI , which uses generative artificial intelligence to provide Snowflake performance and cost optimization insights and maximize customer return on investment. Certifications include Snowflake Data Superhero, Snowflake Subject Matter Expert, SnowPro Core, and SnowPro Advanced Architect.

## Responses 1

Markdown supported · ⌘↵ to post

[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!
