What is the MINIMUM role required to set the value for the parameter ENABLE_ACCOUNT_DATABASE_REPLICATION?
What is the MINIMUM role required to set the value for the parameter ENABLE_ACCOUNT_DATABASE_REPLICATION?
The minimum role required to set the value for the parameter ENABLE_ACCOUNT_DATABASE_REPLICATION is ORGADMIN. This is because the function SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER, which is used to set this parameter, can only be executed by users with the ORGADMIN role. This role has the necessary permissions to manage account replication settings across the organization.
its ORG AdMIN
To enable replication for accounts, a user with the ORGADMIN role uses the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function to set the ENABLE_ACCOUNT_DATABASE_REPLICATION parameter to true. Note that multiple accounts in an organization can be enabled for replication from the same ORGADMIN account.
https://docs.snowflake.com/en/user-guide/account-replication-config#label-enabling-accounts-for-replication To enable replication for accounts, a user with the ORGADMIN role uses the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function to set the ENABLE_ACCOUNT_DATABASE_REPLICATION parameter to true. Note that multiple accounts in an organization can be enabled for replication from the same ORGADMIN account.
D https://docs.snowflake.com/en/user-guide/account-replication-config Enable Replication for Accounts in the Organization The organization administrator (ORGADMIN role) must enable replication for the source and target accounts. To enable replication for accounts, a user with the ORGADMIN role uses the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function to set the ENABLE_ACCOUNT_DATABASE_REPLICATION parameter to true. Note that multiple accounts in an organization can be enabled for replication from the same ORGADMIN account. Log into an ORGADMIN account to enable replication for each source and target account in your organization. USE ROLE ORGADMIN; -- View the list of the accounts in your organization -- Note the organization name and account name for each account for which you are enabling replication SHOW ORGANIZATION ACCOUNTS; -- Enable replication by executing this statement for each source and target account in your organization SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER('<organization_name>.<account_name>', 'ENABLE_ACCOUNT_DATABASE_REPLICATION', 'true
The question says minimum role so its A see https://docs.snowflake.com/en/sql-reference/sql/alter-database
https://docs.snowflake.com/en/user-guide/database-replication-config
https://docs.snowflake.com/en/sql-reference/functions/system_global_account_set_parameter
The organization administrator (ORGADMIN role) must enable replication for the source and target accounts before replicating a database https://docs.snowflake.com/en/user-guide/database-replication-config#
Only organization administrators (i.e. users with the ORGADMIN role) can call this SQL function.