A user can change object parameters using which of the following roles?

The correct answer is C. ACCOUNTADMIN, USER with PRIVILEGE. In Snowflake, object parameters (such as DATA_RETENTION_TIME_IN_DAYS, MAX_CLUSTER_COUNT, etc.) can be changed by the ACCOUNTADMIN role, which has unrestricted access to all account-level and object-level settings. Additionally, any user/role that has been explicitly granted the M

Accounts and Security

Question

Options

AACCOUNTADMIN, SECURITYADMIN
BSYSADMIN, SECURITYADMIN
CACCOUNTADMIN, USER with PRIVILEGE
DSECURITYADMIN, USER with PRIVILEGE

How the community answered

(38 responses)

A
3% (1)
B
3% (1)
C
95% (36)

Explanation

In Snowflake, object parameters (such as DATA_RETENTION_TIME_IN_DAYS, MAX_CLUSTER_COUNT, etc.) can be changed by the ACCOUNTADMIN role, which has unrestricted access to all account-level and object-level settings. Additionally, any user/role that has been explicitly granted the MODIFY privilege on the specific object can also alter its parameters. SECURITYADMIN is focused on managing users, roles, and role grants-it does not inherently have the right to change object parameters unless that privilege is also granted. SYSADMIN manages database objects but needs explicit ownership or MODIFY privilege on the target object.

Topics

#Snowflake Roles#RBAC#Privileges#Object Management

Community Discussion

No community discussion yet for this question.

Full ARA-C01 Practice