// 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