title: GRANT EXECUTE permission to ALL STORED PROCEDURES in snowflake
body: <p>GRANT EXECUTE permission to ALL STORED PROCEDURES in snowflake.</p>
  
  <p>I have create a stored procedure in the snowflake database but I am getting error while trying to execute that stored procedure.</p>
  
  <pre><code>create or replace procedure get_column_scale(column_index float)
      returns float not null
      language javascript
      as
      $$
      var stmt = snowflake.createStatement(
          {sqlText: "select EmployeeKey, EmployeeCode from stproc_test_employees;"}
          );
      stmt.execute();  // ignore the result set; we just want the scale.
      return stmt.getColumnScale(COLUMN_INDEX); // Get by column index (1-based)
      $$
      ;
  </code></pre>
  
  <p>i am executing like below </p>
  
  <pre><code>CALL get_column_scale(1);
  </code></pre>
  
  <p>I'm getting this error when trying to execute the stored procedure with Snowflake</p>
  
  <blockquote>
    <p>Error [100183] [P0000]: Execution error in stored procedure GET_COLUMN_SCALE:<br>
    compilation error:<br>
    'SYEMPLOYEES' does not exist or not authorized.<br>
    Statement.execute, line 5 position 9</p>
  </blockquote>
  
  <p>I am thinking it's execute permission i need to add but I don't have idea where need to configure stored procedure permission in Snowflake.</p>
  
  <p>Is anyone have idea about to give permission for stored procedure/table?</p>