- Categories:
System functions (System Information)
SYSTEM$ACTIVATE_CMK_INFO¶
Activates Tri-Secret Secure in your account, using the CMK (customer-managed key) information that you registered for your account.
This system function:
Configures your account to use Tri-Secret Secure with the registered CMK.
Creates a new composed account master key.
Registers your account with the rekeying background service.
Optionally, enables private connectivity on an active CMK, without rekeying.
- See also:
Syntax¶
SYSTEM$ACTIVATE_CMK_INFO( [ 'REKEY_SAME_CMK' ] )
Arguments¶
Required
None.
Optional
'REKEY_SAME_CMK'Allows rekeying with the active CMK.
Returns¶
Success or error messages.
Access control requirements¶
Only users granted the MODIFY privilege on the account can call this function. The MODIFY privilege on an account is typically granted only to the ACCOUNTADMIN role.
Usage notes¶
The background service generates email messages that notify the account administrator about rekeying and Tri-Secret Secure activation status.
Examples¶
Activate Tri-Secret Secure for your Snowflake account:
SELECT SYSTEM$ACTIVATE_CMK_INFO();
Re-key with your current CMK:
SELECT SYSTEM$ACTIVATE_CMK_INFO('REKEY_SAME_CMK');