IMPORTANT
This article is no longer being maintained/updated and will be archived at a future date (TBD).
For up-to-date information about this behavior change, see
2023_03 Bundle (in the Snowflake Documentation)
This behavior change is in the 2023_03 bundle.
The REPLICATE privilege grants the ability to refresh a secondary replication or failover group. A user with the REPLICATE privilege granted to a primary role (the current role activated by executing the USE ROLE command) or any secondary role (activated by executing the USE SECONDARY ROLES command) can successfully refresh a secondary replication or failover group.
A secondary replication or failover group can be refreshed by executing the respective command:
In a future release, this behavior will change as follows:
|
Currently:
|
A user with a role that is granted the REPLICATE privilege activated as either the primary or secondary role can successfully refresh a secondary replication or failover group.
|
|
Pending:
|
A user with a role that is granted the REPLICATE privilege must have the role activated as the primary role to successfully refresh a secondary replication or failover group.
Otherwise, executing the refresh command will fail.
|
Ref: 1042
