- Catégories :
Fonctions système (Informations système)
SYSTEM$VERIFY_CMK_INFO_POSTGRES¶
Vérifie la configuration de votre clé gérée par le client (CMK) pour Snowflake Postgres Tri-Secret Secure et renvoie un message concernant la CMK enregistrée.
Syntaxe¶
SYSTEM$VERIFY_CMK_INFO_POSTGRES()
Renvoie¶
Renvoie un message de statut positif ou des informations sur l’échec de la vérification :
AWS :
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | SYSTEM$VERIFY_CMK_INFO_POSTGRES() | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Verification failed due to an exception with message: Access is denied to the customer managed key (CMK) for this account. This could be because: 1) the CMK access permissions granted to Snowflake have been revoked OR 2) the CMK is disabled OR 3) the CMK is scheduled for deletion OR 4) the CMK specified is wrong. CMK ARN used: arn:aws:kms:us-west-2:736112632311:key/ceab36e4-f0e5-4b46-9a78-86e8f17a0f59 | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Azure :
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | SYSTEM$VERIFY_CMK_INFO_POSTGRES() | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Verification failed due to an exception with message: Error received from the customer managed key (CMK) provider caused by user: 'Your request cannot be completed because of the failure of an external dependency. Please try again later.'. CMK KEY URI used: https://trisecretsite.vault.azure.net/keys/TriSecretAZKeyWrong | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Exigences en matière de contrôle d’accès¶
Seuls les administrateurs de comptes (les utilisateurs ayant le rôle ACCOUNTADMIN) ou un rôle bénéficiant du privilège MONITOR SECURITY sur le compte peuvent appeler cette fonction.
Exemples¶
Obtenez le statut de la CMK pour votre compte Snowflake :
SELECT SYSTEM$VERIFY_CMK_INFO_POSTGRES();