Skip to content
AWS for Query.Farm

aws.iam.get_account_password_policy

Example SQL Queries

SELECT * FROM
aws.iam.get_account_password_policy;

Description

Retrieves the password policy for the Amazon Web Services account. This tells you the complexity requirements and mandatory rotation periods for the IAM user passwords in your account. For more information about using a password policy, see Managing an IAM password policy.

Table Definition

Column NameColumn Data Type
password_policy

A structure that contains details about the account's password policy.

STRUCT(
    "minimum_password_length" BIGINT,
    "require_symbols" BOOLEAN,
    "require_numbers" BOOLEAN,
    "require_uppercase_characters" BOOLEAN,
    "require_lowercase_characters" BOOLEAN,
    "allow_users_to_change_password" BOOLEAN,
    "expire_passwords" BOOLEAN,
    "max_password_age" BIGINT,
    "password_reuse_prevention" BIGINT,
    "hard_expiry" BOOLEAN
)
Show child fields
password_policy.allow_users_to_change_password

Specifies whether IAM users are allowed to change their own password. Gives IAM users permissions to iam:ChangePassword for only their user and to the iam:GetAccountPasswordPolicy action. This option does not attach a permissions policy to each user, rather the permissions are applied at the account-level for all users by IAM.

password_policy.expire_passwords

Indicates whether passwords in the account expire. Returns true if MaxPasswordAge contains a value greater than 0. Returns false if MaxPasswordAge is 0 or not present.

password_policy.hard_expiry

Specifies whether IAM users are prevented from setting a new password via the Amazon Web Services Management Console after their password has expired. The IAM user cannot access the console until an administrator resets the password. IAM users with iam:ChangePassword permission and active access keys can reset their own expired console password using the CLI or API.

password_policy.max_password_age

The number of days that an IAM user password is valid.

password_policy.minimum_password_length

Minimum length to require for IAM user passwords.

password_policy.password_reuse_prevention

Specifies the number of previous passwords that IAM users are prevented from reusing.

password_policy.require_lowercase_characters

Specifies whether IAM user passwords must contain at least one lowercase character (a to z).

password_policy.require_numbers

Specifies whether IAM user passwords must contain at least one numeric character (0 to 9).

password_policy.require_symbols

Specifies whether IAM user passwords must contain at least one of the following symbols:

! @ # $ % ^ & * ( ) _ + - = [ ] { } | '

password_policy.require_uppercase_characters

Specifies whether IAM user passwords must contain at least one uppercase character (A to Z).