Categories:

System functions (System Control)

SYSTEM$ACTIVATE_CMK_INFO_POSTGRES

Activates Snowflake Postgres Tri-Secret Secure in your account by using the CMK (customer-managed key) information that you registered for your account.

此系统函数将执行以下操作：

  • Configures your account to use Snowflake Postgres Tri-Secret Secure with the registered CMK.
  • 在成功启用已注册的 CMK 之后，新创建的 Snowflake Postgres 实例将使用该配置。
  • Snowflake Postgres instances that were created before the registered CMK is activated will not be rekeyed to use the new CMK, but will continue working with the prior CMK or no CMK.
  • Snowflake Postgres 的副本和分支实例始终会继承其父 Snowflake Postgres 主实例的 CMK 配置。
See also:

Understanding CMK self-registration with support activation of Tri-Secret Secure

语法

SYSTEM$ACTIVATE_CMK_INFO_POSTGRES()

返回

成功或错误消息。

访问控制要求

只有在账户级别被授予 MODIFY 权限的用户，才能调用此函数。MODIFY 权限通常仅授予该 ACCOUNTADMIN 角色。

示例

Activate Snowflake Postgres Tri-Secret Secure for your Snowflake account:

SELECT SYSTEM$ACTIVATE_CMK_INFO_POSTGRES();