0

Is there any way to configure Snowflake to allow only key pair authenticated users' connections?

At the moment you can add RSA_PUBLIC_KEY_FP to any user. But he can connect easily without specifying the key file.

1 Answer 1

1

I figured out the solution:

  1. Create public/private key pair
  2. Assign public key to a Snowflake user, e.g. alter user testuser set rsa_public_key='ADNDDBgkqh...';
  3. Set the user's password to null: alter user testuser set password = null;
  4. For connection don't forget to specify properties: private_key_file and private_key_file_pwd

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.