管理自动履行权限

您可以委派权限、撤销权限以及确定权限是否已委派给特定账户。您只能将权限委派给您组织中的其他账户。

委派自动履行的设置权限

将权限委派给 ACCOUNTADMIN 角色后，ACCOUNTADMIN 角色即可将 MANAGE LISTING AUTO FULFILLMENT 权限授予账户中的其他角色。

USE ROLE ACCOUNTADMIN;
GRANT MANAGE LISTING AUTO FULFILLMENT ON ACCOUNT TO ROLE <role_name>;

将权限委派给 ACCOUNTADMIN 角色后，ACCOUNTADMIN 角色即可将 MANAGE LISTING AUTO FULFILLMENT 权限授予账户中的其他角色。

USE ROLE ACCOUNTADMIN;
REVOKE MANAGE LISTING AUTO FULFILLMENT ON ACCOUNT FROM ROLE <my_role>;

Verify whether auto-fulfillment is enabled for an account¶

To determine whether auto-fulfillment is enabled on an account, call the SYSTEM$IS_GLOBAL_DATA_SHARING_ENABLED_FOR_ACCOUNT system function. The arguments for this system function are described below.

调用该系统函数需要 ORGADMIN 角色。

SELECT SYSTEM$IS_GLOBAL_DATA_SHARING_ENABLED_FOR_ACCOUNT(
  '<account_name>'
  );

其中：

account_name: Specifies the name of the account for which you want to check if users with the ACCOUNTADMIN role can manage auto-fulfillment. See Finding the organization and account name for an account.