<budget_name>!CONFIRM_CUSTOM_ACTIONS_ACCESS

Validate that the stored procedures associated with custom actions are still valid and that required access control privileges are still granted.

To fix any problems, see Stored procedure requirements.

See also:

<budget_name>!ADD_CUSTOM_ACTION, <budget_name>!GET_CUSTOM_ACTIONS

语法

<budget_name>!CONFIRM_CUSTOM_ACTIONS_ACCESS()

返回

该方法会返回以下列：

Column nameData typeDescription
PROCEDURE_FQNVARCHARFully qualified name of the stored procedure.
IS_VALIDBOOLEANIf TRUE, the stored procedure is still valid and the SNOWFLAKE application still has the required privileges on the procedure.
REASONVARCHARExplanation of why the custom action is no longer valid.

访问控制要求

  • 查看 自定义预算 的结果需要以下最低权限和角色：

    • Any instance role for the budget instance.
    • 对包含预算实例的数据库和架构的 USAGE 权限。

  • 需要以下角色才能查看 账户预算 的结果：

For more information, see Budgets roles and privileges.

使用说明

Calling this method does not return the object. Because of this, you can’t use method chaining to call another method on the return value of this method. Instead, call each method in a separate SQL statement.

示例

Verify the stored procedures and permissions for budget my_budget in schema budget_db.sch1:

CALL budget_db.sch1.my_budget!CONFIRM_CUSTOM_ACTIONS_ACCESS();

验证账户预算的存储过程和权限：

CALL snowflake.local.account_root_budget!CONFIRM_CUSTOM_ACTIONS_ACCESS();