A.
The GLOBAL privilege CREATE TASK is required to create a new task.
B.
Tasks are created at the Application level and can only be created by the Account Admin role.
C.
Many Snowflake DDLs are metadata operations only, and CREATE TASK DDL can be executed without virtual warehouse requirement or task specific grants.
D.
The role must have access to the target schema and the CREATE TASK privilege on the schema itself.
D. The role must have access to the target schema and the CREATE TASK privilege on the schema itself: The role executing the CREATE TASK statement must have access privileges on the schema where the task will be created. This includes having the necessary privileges to create objects within the schema. Typically, the role needs the CREATE TASK privilege granted on the specific schema.
D. The role must have access to the target schema and the CREATE TASK privilege on the schema itself.
In Snowflake, to create a task, the role must have access to the target schema where the task will be created, and it needs the CREATE TASK privilege on that schema. This ensures that users can only create tasks in schemas where they have been granted the necessary permissions
Ans is D
Global Privileges dont have CREATE TASK in it
CREATE TASK is present in Schema level privileges only
Doc: https://docs.snowflake.com/en/user-guide/security-access-control-privileges
Only CREATE TASK at the schema level is required, not global.
All tasks in a simple tree must have the same task owner (i.e. a single role must have the OWNERSHIP privilege on all of the tasks in the tree). All tasks in a simple tree must exist in the same schema.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
shubtred
Highly Voted 1 year, 10 months agopranalig
Most Recent 11 months agoPrashantGupta1616
11 months, 1 week agokrishnak2244
1 year, 11 months agoMayuri917233
2 years agoSV1122
2 years, 4 months agojw1806
2 years, 1 month agoTapasgup007
2 years, 5 months agobharathmv
2 years, 8 months agoarunshai
3 years, 3 months agoSid460545
3 years, 3 months agoarpit_dataguy
3 years, 3 months agoredsky0
3 years, 4 months ago