Query: Disable Snowflake authentication for all non-administrator users

Description

For users who don't require a password in Snowflake, set the password property to null. This will ensure that the password as an authentication method isn't available to those users, and they can't set the password themselves.

Query

Tables used in this query:

• snowflake_role_grant
• snowflake_user

Controls using this query:

• Disable Snowflake authentication for all non-administrator users

SQL