Requirements And Setup
CREATE ROLE IF NOT EXISTS CONSUMER_ADMIN;
GRANT ROLE CONSUMER_ADMIN TO ROLE ACCOUNTADMIN;GRANT CREATE DATABASE, IMPORT SHARE ON ACCOUNT TO ROLE CONSUMER_ADMIN WITH GRANT OPTION;
GRANT CREATE APPLICATION ON ACCOUNT TO ROLE CONSUMER_ADMIN;
GRANT EXECUTE TASK, EXECUTE MANAGED TASK ON ACCOUNT TO ROLE CONSUMER_ADMIN WITH GRANT OPTION;
GRANT USAGE ON WAREHOUSE <insert warehouse name> TO ROLE CONSUMER_ADMIN WITH GRANT OPTION;
GRANT CREATE WAREHOUSE ON ACCOUNT TO ROLE CONSUMER_ADMIN WITH GRANT OPTION;
Last updated