管理自动履行权限¶

After auto-fulfillment is enabled on an account, the ACCOUNTADMIN role can delegate the MANAGE LISTING AUTO FULFILLMENT privilege to other roles in the account, revoke the privileges, and determine whether the privileges have been delegated to a specific account within their organization.

委派自动履行的设置权限¶

After enabling auto-fulfillment on an account, the ACCOUNTADMIN role can grant the MANAGE LISTING AUTO FULFILLMENT privilege to other roles in the account.

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

Copy

The ACCOUNTADMIN role can also revoke the MANAGE LISTING AUTO FULFILLMENT privilege.

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

Copy

验证是否为账户启用了自动履行¶

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>'
  );

Copy

其中：

account_name: 指定要检查的账户名称，以确定具有 ACCOUNTADMIN 角色的用户是否可以管理自动履行。请参阅查找账户的组织和账户名称。