By default, which role has access to the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function?
By default, which role has access to the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function?
The SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function is specifically designed for organization-wide settings in Snowflake. By default, only the ORGADMIN role has the necessary permissions to modify these global account parameters, making it the correct answer.
The function enables replication and failover features for a specified account in an organization. Once an organization administrator (a user with the ORGADMIN role) has called this function, the following features are enabled for the account: Replication Client Redirect
D is the correct answer
https://docs.snowflake.com/en/sql-reference/functions/system_global_account_set_parameter Only organization administrators (i.e. users with the ORGADMIN role) can call this SQL function.
Answer- A