snowflake.PasswordPolicy
Explore with Pulumi AI
A password policy specifies the requirements that must be met to create and reset a password to authenticate to Snowflake.
Create PasswordPolicy Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new PasswordPolicy(name: string, args: PasswordPolicyArgs, opts?: CustomResourceOptions);
@overload
def PasswordPolicy(resource_name: str,
args: PasswordPolicyArgs,
opts: Optional[ResourceOptions] = None)
@overload
def PasswordPolicy(resource_name: str,
opts: Optional[ResourceOptions] = None,
schema: Optional[str] = None,
database: Optional[str] = None,
min_age_days: Optional[int] = None,
min_length: Optional[int] = None,
lockout_time_mins: Optional[int] = None,
max_age_days: Optional[int] = None,
max_length: Optional[int] = None,
max_retries: Optional[int] = None,
comment: Optional[str] = None,
if_not_exists: Optional[bool] = None,
min_lower_case_chars: Optional[int] = None,
min_numeric_chars: Optional[int] = None,
min_special_chars: Optional[int] = None,
min_upper_case_chars: Optional[int] = None,
name: Optional[str] = None,
or_replace: Optional[bool] = None,
history: Optional[int] = None)
func NewPasswordPolicy(ctx *Context, name string, args PasswordPolicyArgs, opts ...ResourceOption) (*PasswordPolicy, error)
public PasswordPolicy(string name, PasswordPolicyArgs args, CustomResourceOptions? opts = null)
public PasswordPolicy(String name, PasswordPolicyArgs args)
public PasswordPolicy(String name, PasswordPolicyArgs args, CustomResourceOptions options)
type: snowflake:PasswordPolicy
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
Parameters
- name string
- The unique name of the resource.
- args PasswordPolicyArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- resource_name str
- The unique name of the resource.
- args PasswordPolicyArgs
- The arguments to resource properties.
- opts ResourceOptions
- Bag of options to control resource's behavior.
- ctx Context
- Context object for the current deployment.
- name string
- The unique name of the resource.
- args PasswordPolicyArgs
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args PasswordPolicyArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args PasswordPolicyArgs
- The arguments to resource properties.
- options CustomResourceOptions
- Bag of options to control resource's behavior.
Constructor example
The following reference example uses placeholder values for all input properties.
var passwordPolicyResource = new Snowflake.PasswordPolicy("passwordPolicyResource", new()
{
Schema = "string",
Database = "string",
MinAgeDays = 0,
MinLength = 0,
LockoutTimeMins = 0,
MaxAgeDays = 0,
MaxLength = 0,
MaxRetries = 0,
Comment = "string",
IfNotExists = false,
MinLowerCaseChars = 0,
MinNumericChars = 0,
MinSpecialChars = 0,
MinUpperCaseChars = 0,
Name = "string",
OrReplace = false,
History = 0,
});
example, err := snowflake.NewPasswordPolicy(ctx, "passwordPolicyResource", &snowflake.PasswordPolicyArgs{
Schema: pulumi.String("string"),
Database: pulumi.String("string"),
MinAgeDays: pulumi.Int(0),
MinLength: pulumi.Int(0),
LockoutTimeMins: pulumi.Int(0),
MaxAgeDays: pulumi.Int(0),
MaxLength: pulumi.Int(0),
MaxRetries: pulumi.Int(0),
Comment: pulumi.String("string"),
IfNotExists: pulumi.Bool(false),
MinLowerCaseChars: pulumi.Int(0),
MinNumericChars: pulumi.Int(0),
MinSpecialChars: pulumi.Int(0),
MinUpperCaseChars: pulumi.Int(0),
Name: pulumi.String("string"),
OrReplace: pulumi.Bool(false),
History: pulumi.Int(0),
})
var passwordPolicyResource = new PasswordPolicy("passwordPolicyResource", PasswordPolicyArgs.builder()
.schema("string")
.database("string")
.minAgeDays(0)
.minLength(0)
.lockoutTimeMins(0)
.maxAgeDays(0)
.maxLength(0)
.maxRetries(0)
.comment("string")
.ifNotExists(false)
.minLowerCaseChars(0)
.minNumericChars(0)
.minSpecialChars(0)
.minUpperCaseChars(0)
.name("string")
.orReplace(false)
.history(0)
.build());
password_policy_resource = snowflake.PasswordPolicy("passwordPolicyResource",
schema="string",
database="string",
min_age_days=0,
min_length=0,
lockout_time_mins=0,
max_age_days=0,
max_length=0,
max_retries=0,
comment="string",
if_not_exists=False,
min_lower_case_chars=0,
min_numeric_chars=0,
min_special_chars=0,
min_upper_case_chars=0,
name="string",
or_replace=False,
history=0)
const passwordPolicyResource = new snowflake.PasswordPolicy("passwordPolicyResource", {
schema: "string",
database: "string",
minAgeDays: 0,
minLength: 0,
lockoutTimeMins: 0,
maxAgeDays: 0,
maxLength: 0,
maxRetries: 0,
comment: "string",
ifNotExists: false,
minLowerCaseChars: 0,
minNumericChars: 0,
minSpecialChars: 0,
minUpperCaseChars: 0,
name: "string",
orReplace: false,
history: 0,
});
type: snowflake:PasswordPolicy
properties:
comment: string
database: string
history: 0
ifNotExists: false
lockoutTimeMins: 0
maxAgeDays: 0
maxLength: 0
maxRetries: 0
minAgeDays: 0
minLength: 0
minLowerCaseChars: 0
minNumericChars: 0
minSpecialChars: 0
minUpperCaseChars: 0
name: string
orReplace: false
schema: string
PasswordPolicy Resource Properties
To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.
Inputs
In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.
The PasswordPolicy resource accepts the following input properties:
- Database string
- The database this password policy belongs to.
- Schema string
- The schema this password policy belongs to.
- Comment string
- Adds a comment or overwrites an existing comment for the password policy.
- History int
- Specifies the number of the most recent passwords that Snowflake stores. These stored passwords cannot be repeated when a user updates their password value. The current password value does not count towards the history. When you increase the history value, Snowflake saves the previous values. When you decrease the value, Snowflake saves the stored values up to that value that is set. For example, if the history value is 8 and you change the history value to 3, Snowflake stores the most recent 3 passwords and deletes the 5 older password values from the history. Default: 0 Max: 24
- If
Not boolExists - Prevent overwriting a previous password policy with the same name.
- Lockout
Time intMins - Specifies the number of minutes the user account will be locked after exhausting the designated number of password retries (i.e. PASSWORDMAXRETRIES). Supported range: 1 to 999, inclusive. Default: 15
- Max
Age intDays - Specifies the maximum number of days before the password must be changed. Supported range: 0 to 999, inclusive. A value of zero (i.e. 0) indicates that the password does not need to be changed. Snowflake does not recommend choosing this value for a default account-level password policy or for any user-level policy. Instead, choose a value that meets your internal security guidelines. Default: 90, which means the password must be changed every 90 days.
- Max
Length int - Specifies the maximum number of characters the password must contain. This number must be greater than or equal to the sum of PASSWORDMINLENGTH, PASSWORDMINUPPERCASECHARS, and PASSWORDMINLOWERCASECHARS. Supported range: 8 to 256, inclusive. Default: 256
- Max
Retries int - Specifies the maximum number of attempts to enter a password before being locked out. Supported range: 1 to 10, inclusive. Default: 5
- Min
Age intDays - Specifies the number of days the user must wait before a recently changed password can be changed again. Supported range: 0 to 999, inclusive. Default: 0
- Min
Length int - Specifies the minimum number of characters the password must contain. Supported range: 8 to 256, inclusive. Default: 8
- Min
Lower intCase Chars - Specifies the minimum number of lowercase characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- Min
Numeric intChars - Specifies the minimum number of numeric characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- Min
Special intChars - Specifies the minimum number of special characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- Min
Upper intCase Chars - Specifies the minimum number of uppercase characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- Name string
- Identifier for the password policy; must be unique for your account.
- Or
Replace bool - Whether to override a previous password policy with the same name.
- Database string
- The database this password policy belongs to.
- Schema string
- The schema this password policy belongs to.
- Comment string
- Adds a comment or overwrites an existing comment for the password policy.
- History int
- Specifies the number of the most recent passwords that Snowflake stores. These stored passwords cannot be repeated when a user updates their password value. The current password value does not count towards the history. When you increase the history value, Snowflake saves the previous values. When you decrease the value, Snowflake saves the stored values up to that value that is set. For example, if the history value is 8 and you change the history value to 3, Snowflake stores the most recent 3 passwords and deletes the 5 older password values from the history. Default: 0 Max: 24
- If
Not boolExists - Prevent overwriting a previous password policy with the same name.
- Lockout
Time intMins - Specifies the number of minutes the user account will be locked after exhausting the designated number of password retries (i.e. PASSWORDMAXRETRIES). Supported range: 1 to 999, inclusive. Default: 15
- Max
Age intDays - Specifies the maximum number of days before the password must be changed. Supported range: 0 to 999, inclusive. A value of zero (i.e. 0) indicates that the password does not need to be changed. Snowflake does not recommend choosing this value for a default account-level password policy or for any user-level policy. Instead, choose a value that meets your internal security guidelines. Default: 90, which means the password must be changed every 90 days.
- Max
Length int - Specifies the maximum number of characters the password must contain. This number must be greater than or equal to the sum of PASSWORDMINLENGTH, PASSWORDMINUPPERCASECHARS, and PASSWORDMINLOWERCASECHARS. Supported range: 8 to 256, inclusive. Default: 256
- Max
Retries int - Specifies the maximum number of attempts to enter a password before being locked out. Supported range: 1 to 10, inclusive. Default: 5
- Min
Age intDays - Specifies the number of days the user must wait before a recently changed password can be changed again. Supported range: 0 to 999, inclusive. Default: 0
- Min
Length int - Specifies the minimum number of characters the password must contain. Supported range: 8 to 256, inclusive. Default: 8
- Min
Lower intCase Chars - Specifies the minimum number of lowercase characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- Min
Numeric intChars - Specifies the minimum number of numeric characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- Min
Special intChars - Specifies the minimum number of special characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- Min
Upper intCase Chars - Specifies the minimum number of uppercase characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- Name string
- Identifier for the password policy; must be unique for your account.
- Or
Replace bool - Whether to override a previous password policy with the same name.
- database String
- The database this password policy belongs to.
- schema String
- The schema this password policy belongs to.
- comment String
- Adds a comment or overwrites an existing comment for the password policy.
- history Integer
- Specifies the number of the most recent passwords that Snowflake stores. These stored passwords cannot be repeated when a user updates their password value. The current password value does not count towards the history. When you increase the history value, Snowflake saves the previous values. When you decrease the value, Snowflake saves the stored values up to that value that is set. For example, if the history value is 8 and you change the history value to 3, Snowflake stores the most recent 3 passwords and deletes the 5 older password values from the history. Default: 0 Max: 24
- if
Not BooleanExists - Prevent overwriting a previous password policy with the same name.
- lockout
Time IntegerMins - Specifies the number of minutes the user account will be locked after exhausting the designated number of password retries (i.e. PASSWORDMAXRETRIES). Supported range: 1 to 999, inclusive. Default: 15
- max
Age IntegerDays - Specifies the maximum number of days before the password must be changed. Supported range: 0 to 999, inclusive. A value of zero (i.e. 0) indicates that the password does not need to be changed. Snowflake does not recommend choosing this value for a default account-level password policy or for any user-level policy. Instead, choose a value that meets your internal security guidelines. Default: 90, which means the password must be changed every 90 days.
- max
Length Integer - Specifies the maximum number of characters the password must contain. This number must be greater than or equal to the sum of PASSWORDMINLENGTH, PASSWORDMINUPPERCASECHARS, and PASSWORDMINLOWERCASECHARS. Supported range: 8 to 256, inclusive. Default: 256
- max
Retries Integer - Specifies the maximum number of attempts to enter a password before being locked out. Supported range: 1 to 10, inclusive. Default: 5
- min
Age IntegerDays - Specifies the number of days the user must wait before a recently changed password can be changed again. Supported range: 0 to 999, inclusive. Default: 0
- min
Length Integer - Specifies the minimum number of characters the password must contain. Supported range: 8 to 256, inclusive. Default: 8
- min
Lower IntegerCase Chars - Specifies the minimum number of lowercase characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- min
Numeric IntegerChars - Specifies the minimum number of numeric characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- min
Special IntegerChars - Specifies the minimum number of special characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- min
Upper IntegerCase Chars - Specifies the minimum number of uppercase characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- name String
- Identifier for the password policy; must be unique for your account.
- or
Replace Boolean - Whether to override a previous password policy with the same name.
- database string
- The database this password policy belongs to.
- schema string
- The schema this password policy belongs to.
- comment string
- Adds a comment or overwrites an existing comment for the password policy.
- history number
- Specifies the number of the most recent passwords that Snowflake stores. These stored passwords cannot be repeated when a user updates their password value. The current password value does not count towards the history. When you increase the history value, Snowflake saves the previous values. When you decrease the value, Snowflake saves the stored values up to that value that is set. For example, if the history value is 8 and you change the history value to 3, Snowflake stores the most recent 3 passwords and deletes the 5 older password values from the history. Default: 0 Max: 24
- if
Not booleanExists - Prevent overwriting a previous password policy with the same name.
- lockout
Time numberMins - Specifies the number of minutes the user account will be locked after exhausting the designated number of password retries (i.e. PASSWORDMAXRETRIES). Supported range: 1 to 999, inclusive. Default: 15
- max
Age numberDays - Specifies the maximum number of days before the password must be changed. Supported range: 0 to 999, inclusive. A value of zero (i.e. 0) indicates that the password does not need to be changed. Snowflake does not recommend choosing this value for a default account-level password policy or for any user-level policy. Instead, choose a value that meets your internal security guidelines. Default: 90, which means the password must be changed every 90 days.
- max
Length number - Specifies the maximum number of characters the password must contain. This number must be greater than or equal to the sum of PASSWORDMINLENGTH, PASSWORDMINUPPERCASECHARS, and PASSWORDMINLOWERCASECHARS. Supported range: 8 to 256, inclusive. Default: 256
- max
Retries number - Specifies the maximum number of attempts to enter a password before being locked out. Supported range: 1 to 10, inclusive. Default: 5
- min
Age numberDays - Specifies the number of days the user must wait before a recently changed password can be changed again. Supported range: 0 to 999, inclusive. Default: 0
- min
Length number - Specifies the minimum number of characters the password must contain. Supported range: 8 to 256, inclusive. Default: 8
- min
Lower numberCase Chars - Specifies the minimum number of lowercase characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- min
Numeric numberChars - Specifies the minimum number of numeric characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- min
Special numberChars - Specifies the minimum number of special characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- min
Upper numberCase Chars - Specifies the minimum number of uppercase characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- name string
- Identifier for the password policy; must be unique for your account.
- or
Replace boolean - Whether to override a previous password policy with the same name.
- database str
- The database this password policy belongs to.
- schema str
- The schema this password policy belongs to.
- comment str
- Adds a comment or overwrites an existing comment for the password policy.
- history int
- Specifies the number of the most recent passwords that Snowflake stores. These stored passwords cannot be repeated when a user updates their password value. The current password value does not count towards the history. When you increase the history value, Snowflake saves the previous values. When you decrease the value, Snowflake saves the stored values up to that value that is set. For example, if the history value is 8 and you change the history value to 3, Snowflake stores the most recent 3 passwords and deletes the 5 older password values from the history. Default: 0 Max: 24
- if_
not_ boolexists - Prevent overwriting a previous password policy with the same name.
- lockout_
time_ intmins - Specifies the number of minutes the user account will be locked after exhausting the designated number of password retries (i.e. PASSWORDMAXRETRIES). Supported range: 1 to 999, inclusive. Default: 15
- max_
age_ intdays - Specifies the maximum number of days before the password must be changed. Supported range: 0 to 999, inclusive. A value of zero (i.e. 0) indicates that the password does not need to be changed. Snowflake does not recommend choosing this value for a default account-level password policy or for any user-level policy. Instead, choose a value that meets your internal security guidelines. Default: 90, which means the password must be changed every 90 days.
- max_
length int - Specifies the maximum number of characters the password must contain. This number must be greater than or equal to the sum of PASSWORDMINLENGTH, PASSWORDMINUPPERCASECHARS, and PASSWORDMINLOWERCASECHARS. Supported range: 8 to 256, inclusive. Default: 256
- max_
retries int - Specifies the maximum number of attempts to enter a password before being locked out. Supported range: 1 to 10, inclusive. Default: 5
- min_
age_ intdays - Specifies the number of days the user must wait before a recently changed password can be changed again. Supported range: 0 to 999, inclusive. Default: 0
- min_
length int - Specifies the minimum number of characters the password must contain. Supported range: 8 to 256, inclusive. Default: 8
- min_
lower_ intcase_ chars - Specifies the minimum number of lowercase characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- min_
numeric_ intchars - Specifies the minimum number of numeric characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- min_
special_ intchars - Specifies the minimum number of special characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- min_
upper_ intcase_ chars - Specifies the minimum number of uppercase characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- name str
- Identifier for the password policy; must be unique for your account.
- or_
replace bool - Whether to override a previous password policy with the same name.
- database String
- The database this password policy belongs to.
- schema String
- The schema this password policy belongs to.
- comment String
- Adds a comment or overwrites an existing comment for the password policy.
- history Number
- Specifies the number of the most recent passwords that Snowflake stores. These stored passwords cannot be repeated when a user updates their password value. The current password value does not count towards the history. When you increase the history value, Snowflake saves the previous values. When you decrease the value, Snowflake saves the stored values up to that value that is set. For example, if the history value is 8 and you change the history value to 3, Snowflake stores the most recent 3 passwords and deletes the 5 older password values from the history. Default: 0 Max: 24
- if
Not BooleanExists - Prevent overwriting a previous password policy with the same name.
- lockout
Time NumberMins - Specifies the number of minutes the user account will be locked after exhausting the designated number of password retries (i.e. PASSWORDMAXRETRIES). Supported range: 1 to 999, inclusive. Default: 15
- max
Age NumberDays - Specifies the maximum number of days before the password must be changed. Supported range: 0 to 999, inclusive. A value of zero (i.e. 0) indicates that the password does not need to be changed. Snowflake does not recommend choosing this value for a default account-level password policy or for any user-level policy. Instead, choose a value that meets your internal security guidelines. Default: 90, which means the password must be changed every 90 days.
- max
Length Number - Specifies the maximum number of characters the password must contain. This number must be greater than or equal to the sum of PASSWORDMINLENGTH, PASSWORDMINUPPERCASECHARS, and PASSWORDMINLOWERCASECHARS. Supported range: 8 to 256, inclusive. Default: 256
- max
Retries Number - Specifies the maximum number of attempts to enter a password before being locked out. Supported range: 1 to 10, inclusive. Default: 5
- min
Age NumberDays - Specifies the number of days the user must wait before a recently changed password can be changed again. Supported range: 0 to 999, inclusive. Default: 0
- min
Length Number - Specifies the minimum number of characters the password must contain. Supported range: 8 to 256, inclusive. Default: 8
- min
Lower NumberCase Chars - Specifies the minimum number of lowercase characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- min
Numeric NumberChars - Specifies the minimum number of numeric characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- min
Special NumberChars - Specifies the minimum number of special characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- min
Upper NumberCase Chars - Specifies the minimum number of uppercase characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- name String
- Identifier for the password policy; must be unique for your account.
- or
Replace Boolean - Whether to override a previous password policy with the same name.
Outputs
All input properties are implicitly available as output properties. Additionally, the PasswordPolicy resource produces the following output properties:
- Fully
Qualified stringName - Fully qualified name of the resource. For more information, see object name resolution.
- Id string
- The provider-assigned unique ID for this managed resource.
- Fully
Qualified stringName - Fully qualified name of the resource. For more information, see object name resolution.
- Id string
- The provider-assigned unique ID for this managed resource.
- fully
Qualified StringName - Fully qualified name of the resource. For more information, see object name resolution.
- id String
- The provider-assigned unique ID for this managed resource.
- fully
Qualified stringName - Fully qualified name of the resource. For more information, see object name resolution.
- id string
- The provider-assigned unique ID for this managed resource.
- fully_
qualified_ strname - Fully qualified name of the resource. For more information, see object name resolution.
- id str
- The provider-assigned unique ID for this managed resource.
- fully
Qualified StringName - Fully qualified name of the resource. For more information, see object name resolution.
- id String
- The provider-assigned unique ID for this managed resource.
Look up Existing PasswordPolicy Resource
Get an existing PasswordPolicy resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.
public static get(name: string, id: Input<ID>, state?: PasswordPolicyState, opts?: CustomResourceOptions): PasswordPolicy
@staticmethod
def get(resource_name: str,
id: str,
opts: Optional[ResourceOptions] = None,
comment: Optional[str] = None,
database: Optional[str] = None,
fully_qualified_name: Optional[str] = None,
history: Optional[int] = None,
if_not_exists: Optional[bool] = None,
lockout_time_mins: Optional[int] = None,
max_age_days: Optional[int] = None,
max_length: Optional[int] = None,
max_retries: Optional[int] = None,
min_age_days: Optional[int] = None,
min_length: Optional[int] = None,
min_lower_case_chars: Optional[int] = None,
min_numeric_chars: Optional[int] = None,
min_special_chars: Optional[int] = None,
min_upper_case_chars: Optional[int] = None,
name: Optional[str] = None,
or_replace: Optional[bool] = None,
schema: Optional[str] = None) -> PasswordPolicy
func GetPasswordPolicy(ctx *Context, name string, id IDInput, state *PasswordPolicyState, opts ...ResourceOption) (*PasswordPolicy, error)
public static PasswordPolicy Get(string name, Input<string> id, PasswordPolicyState? state, CustomResourceOptions? opts = null)
public static PasswordPolicy get(String name, Output<String> id, PasswordPolicyState state, CustomResourceOptions options)
Resource lookup is not supported in YAML
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- resource_name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- Comment string
- Adds a comment or overwrites an existing comment for the password policy.
- Database string
- The database this password policy belongs to.
- Fully
Qualified stringName - Fully qualified name of the resource. For more information, see object name resolution.
- History int
- Specifies the number of the most recent passwords that Snowflake stores. These stored passwords cannot be repeated when a user updates their password value. The current password value does not count towards the history. When you increase the history value, Snowflake saves the previous values. When you decrease the value, Snowflake saves the stored values up to that value that is set. For example, if the history value is 8 and you change the history value to 3, Snowflake stores the most recent 3 passwords and deletes the 5 older password values from the history. Default: 0 Max: 24
- If
Not boolExists - Prevent overwriting a previous password policy with the same name.
- Lockout
Time intMins - Specifies the number of minutes the user account will be locked after exhausting the designated number of password retries (i.e. PASSWORDMAXRETRIES). Supported range: 1 to 999, inclusive. Default: 15
- Max
Age intDays - Specifies the maximum number of days before the password must be changed. Supported range: 0 to 999, inclusive. A value of zero (i.e. 0) indicates that the password does not need to be changed. Snowflake does not recommend choosing this value for a default account-level password policy or for any user-level policy. Instead, choose a value that meets your internal security guidelines. Default: 90, which means the password must be changed every 90 days.
- Max
Length int - Specifies the maximum number of characters the password must contain. This number must be greater than or equal to the sum of PASSWORDMINLENGTH, PASSWORDMINUPPERCASECHARS, and PASSWORDMINLOWERCASECHARS. Supported range: 8 to 256, inclusive. Default: 256
- Max
Retries int - Specifies the maximum number of attempts to enter a password before being locked out. Supported range: 1 to 10, inclusive. Default: 5
- Min
Age intDays - Specifies the number of days the user must wait before a recently changed password can be changed again. Supported range: 0 to 999, inclusive. Default: 0
- Min
Length int - Specifies the minimum number of characters the password must contain. Supported range: 8 to 256, inclusive. Default: 8
- Min
Lower intCase Chars - Specifies the minimum number of lowercase characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- Min
Numeric intChars - Specifies the minimum number of numeric characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- Min
Special intChars - Specifies the minimum number of special characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- Min
Upper intCase Chars - Specifies the minimum number of uppercase characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- Name string
- Identifier for the password policy; must be unique for your account.
- Or
Replace bool - Whether to override a previous password policy with the same name.
- Schema string
- The schema this password policy belongs to.
- Comment string
- Adds a comment or overwrites an existing comment for the password policy.
- Database string
- The database this password policy belongs to.
- Fully
Qualified stringName - Fully qualified name of the resource. For more information, see object name resolution.
- History int
- Specifies the number of the most recent passwords that Snowflake stores. These stored passwords cannot be repeated when a user updates their password value. The current password value does not count towards the history. When you increase the history value, Snowflake saves the previous values. When you decrease the value, Snowflake saves the stored values up to that value that is set. For example, if the history value is 8 and you change the history value to 3, Snowflake stores the most recent 3 passwords and deletes the 5 older password values from the history. Default: 0 Max: 24
- If
Not boolExists - Prevent overwriting a previous password policy with the same name.
- Lockout
Time intMins - Specifies the number of minutes the user account will be locked after exhausting the designated number of password retries (i.e. PASSWORDMAXRETRIES). Supported range: 1 to 999, inclusive. Default: 15
- Max
Age intDays - Specifies the maximum number of days before the password must be changed. Supported range: 0 to 999, inclusive. A value of zero (i.e. 0) indicates that the password does not need to be changed. Snowflake does not recommend choosing this value for a default account-level password policy or for any user-level policy. Instead, choose a value that meets your internal security guidelines. Default: 90, which means the password must be changed every 90 days.
- Max
Length int - Specifies the maximum number of characters the password must contain. This number must be greater than or equal to the sum of PASSWORDMINLENGTH, PASSWORDMINUPPERCASECHARS, and PASSWORDMINLOWERCASECHARS. Supported range: 8 to 256, inclusive. Default: 256
- Max
Retries int - Specifies the maximum number of attempts to enter a password before being locked out. Supported range: 1 to 10, inclusive. Default: 5
- Min
Age intDays - Specifies the number of days the user must wait before a recently changed password can be changed again. Supported range: 0 to 999, inclusive. Default: 0
- Min
Length int - Specifies the minimum number of characters the password must contain. Supported range: 8 to 256, inclusive. Default: 8
- Min
Lower intCase Chars - Specifies the minimum number of lowercase characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- Min
Numeric intChars - Specifies the minimum number of numeric characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- Min
Special intChars - Specifies the minimum number of special characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- Min
Upper intCase Chars - Specifies the minimum number of uppercase characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- Name string
- Identifier for the password policy; must be unique for your account.
- Or
Replace bool - Whether to override a previous password policy with the same name.
- Schema string
- The schema this password policy belongs to.
- comment String
- Adds a comment or overwrites an existing comment for the password policy.
- database String
- The database this password policy belongs to.
- fully
Qualified StringName - Fully qualified name of the resource. For more information, see object name resolution.
- history Integer
- Specifies the number of the most recent passwords that Snowflake stores. These stored passwords cannot be repeated when a user updates their password value. The current password value does not count towards the history. When you increase the history value, Snowflake saves the previous values. When you decrease the value, Snowflake saves the stored values up to that value that is set. For example, if the history value is 8 and you change the history value to 3, Snowflake stores the most recent 3 passwords and deletes the 5 older password values from the history. Default: 0 Max: 24
- if
Not BooleanExists - Prevent overwriting a previous password policy with the same name.
- lockout
Time IntegerMins - Specifies the number of minutes the user account will be locked after exhausting the designated number of password retries (i.e. PASSWORDMAXRETRIES). Supported range: 1 to 999, inclusive. Default: 15
- max
Age IntegerDays - Specifies the maximum number of days before the password must be changed. Supported range: 0 to 999, inclusive. A value of zero (i.e. 0) indicates that the password does not need to be changed. Snowflake does not recommend choosing this value for a default account-level password policy or for any user-level policy. Instead, choose a value that meets your internal security guidelines. Default: 90, which means the password must be changed every 90 days.
- max
Length Integer - Specifies the maximum number of characters the password must contain. This number must be greater than or equal to the sum of PASSWORDMINLENGTH, PASSWORDMINUPPERCASECHARS, and PASSWORDMINLOWERCASECHARS. Supported range: 8 to 256, inclusive. Default: 256
- max
Retries Integer - Specifies the maximum number of attempts to enter a password before being locked out. Supported range: 1 to 10, inclusive. Default: 5
- min
Age IntegerDays - Specifies the number of days the user must wait before a recently changed password can be changed again. Supported range: 0 to 999, inclusive. Default: 0
- min
Length Integer - Specifies the minimum number of characters the password must contain. Supported range: 8 to 256, inclusive. Default: 8
- min
Lower IntegerCase Chars - Specifies the minimum number of lowercase characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- min
Numeric IntegerChars - Specifies the minimum number of numeric characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- min
Special IntegerChars - Specifies the minimum number of special characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- min
Upper IntegerCase Chars - Specifies the minimum number of uppercase characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- name String
- Identifier for the password policy; must be unique for your account.
- or
Replace Boolean - Whether to override a previous password policy with the same name.
- schema String
- The schema this password policy belongs to.
- comment string
- Adds a comment or overwrites an existing comment for the password policy.
- database string
- The database this password policy belongs to.
- fully
Qualified stringName - Fully qualified name of the resource. For more information, see object name resolution.
- history number
- Specifies the number of the most recent passwords that Snowflake stores. These stored passwords cannot be repeated when a user updates their password value. The current password value does not count towards the history. When you increase the history value, Snowflake saves the previous values. When you decrease the value, Snowflake saves the stored values up to that value that is set. For example, if the history value is 8 and you change the history value to 3, Snowflake stores the most recent 3 passwords and deletes the 5 older password values from the history. Default: 0 Max: 24
- if
Not booleanExists - Prevent overwriting a previous password policy with the same name.
- lockout
Time numberMins - Specifies the number of minutes the user account will be locked after exhausting the designated number of password retries (i.e. PASSWORDMAXRETRIES). Supported range: 1 to 999, inclusive. Default: 15
- max
Age numberDays - Specifies the maximum number of days before the password must be changed. Supported range: 0 to 999, inclusive. A value of zero (i.e. 0) indicates that the password does not need to be changed. Snowflake does not recommend choosing this value for a default account-level password policy or for any user-level policy. Instead, choose a value that meets your internal security guidelines. Default: 90, which means the password must be changed every 90 days.
- max
Length number - Specifies the maximum number of characters the password must contain. This number must be greater than or equal to the sum of PASSWORDMINLENGTH, PASSWORDMINUPPERCASECHARS, and PASSWORDMINLOWERCASECHARS. Supported range: 8 to 256, inclusive. Default: 256
- max
Retries number - Specifies the maximum number of attempts to enter a password before being locked out. Supported range: 1 to 10, inclusive. Default: 5
- min
Age numberDays - Specifies the number of days the user must wait before a recently changed password can be changed again. Supported range: 0 to 999, inclusive. Default: 0
- min
Length number - Specifies the minimum number of characters the password must contain. Supported range: 8 to 256, inclusive. Default: 8
- min
Lower numberCase Chars - Specifies the minimum number of lowercase characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- min
Numeric numberChars - Specifies the minimum number of numeric characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- min
Special numberChars - Specifies the minimum number of special characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- min
Upper numberCase Chars - Specifies the minimum number of uppercase characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- name string
- Identifier for the password policy; must be unique for your account.
- or
Replace boolean - Whether to override a previous password policy with the same name.
- schema string
- The schema this password policy belongs to.
- comment str
- Adds a comment or overwrites an existing comment for the password policy.
- database str
- The database this password policy belongs to.
- fully_
qualified_ strname - Fully qualified name of the resource. For more information, see object name resolution.
- history int
- Specifies the number of the most recent passwords that Snowflake stores. These stored passwords cannot be repeated when a user updates their password value. The current password value does not count towards the history. When you increase the history value, Snowflake saves the previous values. When you decrease the value, Snowflake saves the stored values up to that value that is set. For example, if the history value is 8 and you change the history value to 3, Snowflake stores the most recent 3 passwords and deletes the 5 older password values from the history. Default: 0 Max: 24
- if_
not_ boolexists - Prevent overwriting a previous password policy with the same name.
- lockout_
time_ intmins - Specifies the number of minutes the user account will be locked after exhausting the designated number of password retries (i.e. PASSWORDMAXRETRIES). Supported range: 1 to 999, inclusive. Default: 15
- max_
age_ intdays - Specifies the maximum number of days before the password must be changed. Supported range: 0 to 999, inclusive. A value of zero (i.e. 0) indicates that the password does not need to be changed. Snowflake does not recommend choosing this value for a default account-level password policy or for any user-level policy. Instead, choose a value that meets your internal security guidelines. Default: 90, which means the password must be changed every 90 days.
- max_
length int - Specifies the maximum number of characters the password must contain. This number must be greater than or equal to the sum of PASSWORDMINLENGTH, PASSWORDMINUPPERCASECHARS, and PASSWORDMINLOWERCASECHARS. Supported range: 8 to 256, inclusive. Default: 256
- max_
retries int - Specifies the maximum number of attempts to enter a password before being locked out. Supported range: 1 to 10, inclusive. Default: 5
- min_
age_ intdays - Specifies the number of days the user must wait before a recently changed password can be changed again. Supported range: 0 to 999, inclusive. Default: 0
- min_
length int - Specifies the minimum number of characters the password must contain. Supported range: 8 to 256, inclusive. Default: 8
- min_
lower_ intcase_ chars - Specifies the minimum number of lowercase characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- min_
numeric_ intchars - Specifies the minimum number of numeric characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- min_
special_ intchars - Specifies the minimum number of special characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- min_
upper_ intcase_ chars - Specifies the minimum number of uppercase characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- name str
- Identifier for the password policy; must be unique for your account.
- or_
replace bool - Whether to override a previous password policy with the same name.
- schema str
- The schema this password policy belongs to.
- comment String
- Adds a comment or overwrites an existing comment for the password policy.
- database String
- The database this password policy belongs to.
- fully
Qualified StringName - Fully qualified name of the resource. For more information, see object name resolution.
- history Number
- Specifies the number of the most recent passwords that Snowflake stores. These stored passwords cannot be repeated when a user updates their password value. The current password value does not count towards the history. When you increase the history value, Snowflake saves the previous values. When you decrease the value, Snowflake saves the stored values up to that value that is set. For example, if the history value is 8 and you change the history value to 3, Snowflake stores the most recent 3 passwords and deletes the 5 older password values from the history. Default: 0 Max: 24
- if
Not BooleanExists - Prevent overwriting a previous password policy with the same name.
- lockout
Time NumberMins - Specifies the number of minutes the user account will be locked after exhausting the designated number of password retries (i.e. PASSWORDMAXRETRIES). Supported range: 1 to 999, inclusive. Default: 15
- max
Age NumberDays - Specifies the maximum number of days before the password must be changed. Supported range: 0 to 999, inclusive. A value of zero (i.e. 0) indicates that the password does not need to be changed. Snowflake does not recommend choosing this value for a default account-level password policy or for any user-level policy. Instead, choose a value that meets your internal security guidelines. Default: 90, which means the password must be changed every 90 days.
- max
Length Number - Specifies the maximum number of characters the password must contain. This number must be greater than or equal to the sum of PASSWORDMINLENGTH, PASSWORDMINUPPERCASECHARS, and PASSWORDMINLOWERCASECHARS. Supported range: 8 to 256, inclusive. Default: 256
- max
Retries Number - Specifies the maximum number of attempts to enter a password before being locked out. Supported range: 1 to 10, inclusive. Default: 5
- min
Age NumberDays - Specifies the number of days the user must wait before a recently changed password can be changed again. Supported range: 0 to 999, inclusive. Default: 0
- min
Length Number - Specifies the minimum number of characters the password must contain. Supported range: 8 to 256, inclusive. Default: 8
- min
Lower NumberCase Chars - Specifies the minimum number of lowercase characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- min
Numeric NumberChars - Specifies the minimum number of numeric characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- min
Special NumberChars - Specifies the minimum number of special characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- min
Upper NumberCase Chars - Specifies the minimum number of uppercase characters the password must contain. Supported range: 0 to 256, inclusive. Default: 1
- name String
- Identifier for the password policy; must be unique for your account.
- or
Replace Boolean - Whether to override a previous password policy with the same name.
- schema String
- The schema this password policy belongs to.
Package Details
- Repository
- Snowflake pulumi/pulumi-snowflake
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the
snowflake
Terraform Provider.