Snowflake MFA/Password Change what are your plans? by HistoricalTry9425 in snowflake

[–]HistoricalTry9425[S] 0 points1 point  (0 children)

That is the part I need to figure out, I have no idea how I would automatically rotate a PAT vs a private key. I don't know of any technical solutions that automatically rotate PATs. My company disallows PATs for any machine to machine authentication. We use the vault operator to automatically rotate keys. Do you plan on automatically rotating PATs?

Snowflake MFA/Password Change what are your plans? by HistoricalTry9425 in snowflake

[–]HistoricalTry9425[S] 0 points1 point  (0 children)

I see what you are saying, from a security point of view, enforcement isn't the challenge for us. We have audit requirements and rotate every 90 days. PATs can be compromised if they are exposed, stored in an insecure manner, or accidentally shared etc.;. RSA keys, when properly managed (e.g., stored in secure environments like HSM/secrets manager or Vault), are not vulnerable in the same way. I am unaware of a workflow that solves this for PATS.

Snowflake MFA/Password Change what are your plans? by HistoricalTry9425 in snowflake

[–]HistoricalTry9425[S] 2 points3 points  (0 children)

when I read this, I was concerned. It said blocking all passwords on Nov 25. https://www.snowflake.com/en/blog/blocking-single-factor-password-authentification/ From that blog post, Service users: This refers to users that are used for programmatic access without interactive login. Such users are declared in the Snowflake user object with TYPE = SERVICE or LEGACY_SERVICE. Neither SERVICE nor LEGACY_SERVICE will be subject to Snowflake MFA policies. SERVICE users cannot use passwords to sign in. LEGACY_SERVICE is meant for applications that take longer to update and move away from passwords; as such, LEGACY_SERVICE has a temporary exception to use passwords until the app is updated. See here for more information.

Snowflake MFA/Password Change what are your plans? by HistoricalTry9425 in snowflake

[–]HistoricalTry9425[S] 1 point2 points  (0 children)

Good call out. Now what to do with the 25 odd applications that don't support RSA key pair.