Snowflake stored procedure permission question

To fix the same error, I had to make sure to also grant privileges USAGE ON DATABASE and USAGE ON SCHEMA to the role — otherwise you’ll get the Unknown error when working within that role.

GRANT USAGE ON DATABASE db TO ROLE UAT_OPERATIONS;
GRANT USAGE ON SCHEMA db.public TO ROLE UAT_OPERATIONS;
GRANT USAGE ON PROCEDURE db.PUBLIC.SOME_PROC() TO ROLE UAT_OPERATIONS;

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top