title: snowflake - query grants to role
body: <p>I made all table grants to a role:</p>
  <pre><code>grant select on all tables in               schema WORKING to role PROD_WORKING_SR;
  grant select on all views  in               schema WORKING to role PROD_WORKING_SR;
  grant select on future tables in            schema WORKING to role PROD_WORKING_SR;
  grant select on future views  in            schema WORKING to role PROD_WORKING_SR;
  </code></pre>
  <p>but when I try to verify the grants using command:</p>
  <pre><code>show grants to role PROD_WORKING_SR
  </code></pre>
  <p>I get nothing. Can someone help me with a query that I can extract all privileges granted to a role like I did above.</p>
  <p>Appreciate your help!!!</p>