扩展了 MONITOR、OPERATE、MONITOR、EXECUTION 和 OWNER 权限的任务视图功能（待定）¶

注意

此行为变更在 2025_01 捆绑包中。

有关捆绑包的当前状态，请参阅捆绑包历史记录。

启用此行为变更捆绑包可扩展具有这些权限的角色的能力，以查看任务信息。

变更前:

具有 MONITOR、OPERATE、MONITOR EXECUTION 和 OWNERSHIP 权限的角色无法获得某些任务信息。

变更后:

具有 MONITOR、OPERATE、MONITOR EXECUTION 和 OWNERSHIP 权限时，可用的任务信息会扩展。

下表描述了启用此行为变更捆绑包后现在可用的任务信息。

MONITOR 和 OPERATE 权限¶

	变更前	变更后
SHOW TASKS	✔	✔
DESCRIBE TASK	✔	✔
INFORMATION_SCHEMA 表函数
TASK_HISTORY	❌	✔
CURRENT_TASK_GRAPHS	❌	✔
COMPLETE_TASK_GRAPHS	❌	✔
QUERY_HISTORY、QUERY_HISTORY_BY_*	对于 Serverless Task： ✔ 所有查询 ✔ Stored-procedure child queries that ran with caller's rights. ❌ Stored-procedure child queries that ran with owner's rights. 对于用户管理的任务： ❌ Task privileges do not determine what a role can view in QUERY_HISTORY.	对于 Serverless Task： ✔ 所有查询 ✔ Stored-procedure child queries that ran with caller's rights. ❌ Stored-procedure child queries that ran with owner's rights. 对于用户管理的任务： ✔ Task queries and stored-procedure child queries. ❌ Stored-procedure child queries that ran with owner's rights require at least MONITOR privileges on the warehouse. Task privileges do not grant this visibility.
Snowsight
任务详细信息 > 运行历史记录和监控 > 任务历史记录 > 任务运行	❌	✔
Task details > Graph 和 Monitoring > Task History > Task Graphs	✔	✔

	变更前	变更后
SHOW TASKS	✔	✔
DESCRIBE TASK	✔	✔
INFORMATION_SCHEMA 表函数
TASK_HISTORY	✔	✔
CURRENT_TASK_GRAPHS	✔	✔
COMPLETE_TASK_GRAPHS	✔	✔
QUERY_HISTORY、QUERY_HISTORY_BY_*	❌ Task privileges do not determine what a role can view in QUERY_HISTORY.	对于 Serverless Task： ✔ 所有查询 ✔ Stored-procedure child queries that ran with caller's rights. ❌ Stored-procedure child queries that ran with owner's rights. 对于用户管理的任务： ✔ Task queries and stored-procedure child queries. ❌ Stored-procedure child queries that ran with owner's rights require at least MONITOR privileges on the warehouse. Task privileges do not grant this visibility.
Snowsight
任务详细信息 > 运行历史记录和监控 > 任务历史记录 > 任务运行	✔	✔
Task details > Graph 和 Monitoring > Task History > Task Graphs	✔	✔

	变更前	变更后
SHOW TASKS	✔	✔
DESCRIBE TASK	✔	✔
INFORMATION_SCHEMA 表函数
TASK_HISTORY	✔	✔
CURRENT_TASK_GRAPHS	✔	✔
COMPLETE_TASK_GRAPHS	✔	✔
QUERY_HISTORY、QUERY_HISTORY_BY_*	对于 Serverless Task： ✔ 所有查询 ✔ Stored-procedure child queries that ran with caller's rights. ❌ Stored-procedure child queries that ran with owner's rights. 对于用户管理的任务： ❌ Task privileges do not determine what a role can view in QUERY_HISTORY.	对于 Serverless Task： ✔ 所有查询 ✔ Stored-procedure child queries that ran with caller's rights. ❌ Stored-procedure child queries that ran with owner's rights. 对于用户管理的任务： ✔ Task queries and stored-procedure child queries. ❌ Stored-procedure child queries that ran with owner's rights require at least MONITOR privileges on the warehouse. Task privileges do not grant this visibility.
Snowsight
任务详细信息 > 运行历史记录和监控 > 任务历史记录 > 任务运行	✔	✔
Task details > Graph 和 Monitoring > Task History > Task Graphs	✔	✔

参考：1799