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

A user can change object parameters using which of the following roles?
A . ACCOUNTADMIN, SECURITYADMIN
B . SYSADMIN, SECURITYADMIN
C . ACCOUNTADMIN, USER with PRIVILEGE
D . SECURITYADMIN, USER with PRIVILEGE

View Answer

Answer: C

Explanation:

According to the Snowflake documentation, object parameters are parameters that can be set on individual objects such as databases, schemas, tables, and stages. Object parameters can be set by users with the appropriate privileges on the objects. For example, to set the object parameter AUTO_REFRESH on a table, the user must have the MODIFY privilege on the table. The ACCOUNTADMIN role has the highest level of privileges on all objects in the account, so it can set any object parameter on any object. However, other roles, such as SECURITYADMIN or SYSADMIN, do not have the same level of privileges on all objects, so they cannot set object parameters on objects they do not own or have the required privileges on. Therefore, the correct answer is C. ACCOUNTADMIN, USER with PRIVILEGE.

Reference: Parameters | Snowflake Documentation

Object Parameters | Snowflake Documentation

Object Privileges | Snowflake Documentation