How to Generate the Private Key in Windows

  1. Open a terminal window to create a private key first.
  2. Both an encrypted and an unencrypted copy of the private key are available for creation.
  3. Use the following command to create a version that isn’t encrypted:
openssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -out rsa_key.p8 -nocrypt

Use the following command (omitting “-nocrypt”) to create an encrypted version:

openssl rsa -in rsa_key.p8 -pubout -out rsa_key.pub

Open the rsa_key.pub in notepad and remove the first and last line and copy and create sql like

alter user freshers_usr set rsa_public_key='KLIKKsaMKGReiuiohl........';

Note: Only security administrators or higher can alter a user in snowflake.

Get posts on

Author: user

Leave a Reply