2022-06-19

Snowflake - How to enable the customer support feature, and grant access to it

// Create user support role 
// (required to receive support, un-be-lie-va-ble)

USE ROLE ACCOUNTADMIN

CREATE ROLE USER_SUPPORT

GRANT MANAGE USER SUPPORT CASES ON ACCOUNT TO ROLE USER_SUPPORT


// Grant access to their own cases

USE ROLE ACCOUNTADMIN

GRANT ROLE USER_SUPPORT TO USER USER_NAME_NO_QUOTES;


// Grant access to all access in the account

USE ROLE ACCOUNTADMIN

CREATE ROLE ACCOUNT_SUPPORT;

GRANT MANAGE ACCOUNT SUPPORT CASES ON ACCOUNT TO ROLE ACCOUNT_SUPPORT;


// Grant access to all the organization's cases 

USE ROLE ORGADMIN

CREATE ROLE ORGANIZATION_SUPPORT;

GRANT MANAGE ORGANIZATION SUPPORT CASES ON ACCOUNT TO ROLE ORGANIZATION_SUPPORT;


No comments:

Post a Comment