- Open a terminal window to create a private key first.
- Both an encrypted and an unencrypted copy of the private key are available for creation.
- 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.
