Grant monitor on snowflake task

Question

I am trying to grant the monitor privilege on all current and future tasks in a snowflake database to a particular role.

The documentation offers no examples.

I tried GRANT MONITOR ON ALL TASKS ON DATABASE MY_DB TO ROLE ROLE_OVER

Is something like that possible? Do you have to go schema by schema? Individual task by task?

Answer 1

Try this (IN instead of ON):

GRANT MONITOR ON ALL TASKS IN DATABASE MY_DB TO ROLE ROLE_OVER
;