community.hashi_vault.vault_database_static_role_create module – Create or update a static role

Note

This module is part of the community.hashi_vault collection (version 6.3.0-dev0).

It is not included in ansible-core. To check whether it is installed, run ansible-galaxy collection list.

To install it, use: ansible-galaxy collection install community.hashi_vault. You need further requirements to be able to use this module, see Requirements for details.

To use it in a playbook, specify: community.hashi_vault.vault_database_static_role_create.

New in community.hashi_vault 6.2.0

Synopsis 

Creates a new or updates an existing static role.

Requirements 

The below requirements are needed on the host that executes this module.

hvac (Python library)
For detailed requirements, see the collection requirements page.

Parameters 

Parameter	Comments
auth_method string	Authentication method to be used. `none` auth method was added in collection version `1.2.0`. `cert` auth method was added in collection version `1.4.0`. `aws_iam_login` was renamed `aws_iam` in collection version `2.1.0` and was removed in `3.0.0`. `azure` auth method was added in collection version `3.2.0`. Choices: `"token"` ← (default) `"userpass"` `"ldap"` `"approle"` `"aws_iam"` `"azure"` `"jwt"` `"cert"` `"none"`
aws_access_key aliases: aws_access_key_id string	The AWS access key to use.
aws_iam_server_id string added in community.hashi_vault 0.2.0	If specified, sets the value to use for the `X-Vault-AWS-IAM-Server-ID` header as part of `GetCallerIdentity` request.
aws_profile aliases: boto_profile string	The AWS profile
aws_secret_key aliases: aws_secret_access_key string	The AWS secret key that corresponds to the access key.
aws_security_token string	The AWS security token if using temporary access and secret keys.
azure_client_id string added in community.hashi_vault 3.2.0	The client ID (also known as application ID) of the Azure AD service principal or managed identity. Should be a UUID. If not specified, will use the system assigned managed identity.
azure_client_secret string added in community.hashi_vault 3.2.0	The client secret of the Azure AD service principal.
azure_resource string added in community.hashi_vault 3.2.0	The resource URL for the application registered in Azure Active Directory. Usually should not be changed from the default. Default: `"https://management.azure.com/"`
azure_tenant_id string added in community.hashi_vault 3.2.0	The Azure Active Directory Tenant ID (also known as the Directory ID) of the service principal. Should be a UUID. Required when using a service principal to authenticate to Vault, e.g. required when both azure_client_id and azure_client_secret are specified. Optional when using managed identity to authenticate to Vault.
ca_cert aliases: cacert string	Path to certificate to use for authentication. If not specified by any other means, the `VAULT_CACERT` environment variable will be used.
cert_auth_private_key path added in community.hashi_vault 1.4.0	For `cert` auth, path to the private key file to authenticate with, in PEM format.
cert_auth_public_key path added in community.hashi_vault 1.4.0	For `cert` auth, path to the certificate file to authenticate with, in PEM format.
connection_name string / required	The connection name under which the role should be created.
db_username string / required	The database username - Note that the user must exist in the target database!
engine_mount_point string	The path where the secret backend is mounted.
jwt string	The JSON Web Token (JWT) to use for JWT authentication to Vault.
mount_point string	Vault mount point. If not specified, the default mount point for a given auth method is used. Does not apply to token authentication.
namespace string	Vault namespace where secrets reside. This option requires HVAC 0.7.0+ and Vault 0.11+. Optionally, this may be achieved by prefixing the authentication mount point and/or secret path with the namespace (e.g `mynamespace/secret/mysecret`). If environment variable `VAULT_NAMESPACE` is set, its value will be used last among all ways to specify namespace.
password string	Authentication password.
proxies any added in community.hashi_vault 1.1.0	URL(s) to the proxies used to access the Vault service. It can be a string or a dict. If it’s a dict, provide the scheme (eg. `http` or `https`) as the key, and the URL as the value. If it’s a string, provide a single URL that will be used as the proxy for both `http` and `https` schemes. A string that can be interpreted as a dictionary will be converted to one (see examples). You can specify a different proxy for HTTP and HTTPS resources. If not specified, environment variables from the Requests library are used.
region string	The AWS region for which to create the connection.
retries any added in community.hashi_vault 1.3.0	Allows for retrying on errors, based on the Retry class in the urllib3 library. This collection defines recommended defaults for retrying connections to Vault. This option can be specified as a positive number (integer) or dictionary. If this option is not specified or the number is `0`, then retries are disabled. A number sets the total number of retries, and uses collection defaults for the other settings. A dictionary value is used directly to initialize the `Retry` class, so it can be used to fully customize retries. For detailed information on retries, see the collection User Guide.
retry_action string added in community.hashi_vault 1.3.0	Controls whether and how to show messages on retries. This has no effect if a request is not retried. Choices: `"ignore"` `"warn"` ← (default)
role_id string	Vault Role ID or name. Used in `approle`, `aws_iam`, `azure` and `cert` auth methods. For `cert` auth, if no role_id is supplied, the default behavior is to try all certificate roles and return any one that matches. For `azure` auth, role_id is required.
role_name string / required	The name of the role that should be created.
rotation_period integer	Password rotation period in seconds (defaults to 24hs) Default: `86400`
rotation_statements list / elements=string / required	SQL statements to rotate the password for the given `db_username`
secret_id string	Secret ID to be used for Vault AppRole authentication.
timeout integer added in community.hashi_vault 1.3.0	Sets the connection timeout in seconds. If not set, then the `hvac` library’s default is used.
token string	Vault token. Token may be specified explicitly, through the listed [env] vars, and also through the `VAULT_TOKEN` env var. If no token is supplied, explicitly or through env, then the plugin will check for a token file, as determined by token_path and token_file. The order of token loading (first found wins) is `token param -> ansible var -> ANSIBLE_HASHI_VAULT_TOKEN -> VAULT_TOKEN -> token file`.
token_file string	If no token is specified, will try to read the token from this file in token_path. Default: `".vault-token"`
token_path string	If no token is specified, will try to read the token_file from this path.
token_validate boolean added in community.hashi_vault 0.2.0	For token auth, will perform a `lookup-self` operation to determine the token’s validity before using it. Disable if your token does not have the `lookup-self` capability. Choices: `false` ← (default) `true`
url string	URL to the Vault service. If not specified by any other means, the value of the `VAULT_ADDR` environment variable will be used. If `VAULT_ADDR` is also not defined then an error will be raised.
username string	Authentication user name.
validate_certs boolean	Controls verification and validation of SSL certificates, mostly you only want to turn off with self signed ones. Will be populated with the inverse of `VAULT_SKIP_VERIFY` if that is set and validate_certs is not explicitly provided. Will default to `true` if neither validate_certs or `VAULT_SKIP_VERIFY` are set. Choices: `false` `true`

Attributes 

Attribute	Support	Description
action_group	Action group: community.hashi_vault.vault	Use `group/community.hashi_vault.vault` in `module_defaults` to set defaults for this module.
check_mode	Support: partial In check mode, a sample response will be returned, but the role creation will not be performed in Hashicorp Vault.	Can run in `check_mode` and return changed status prediction without modifying target.

Notes 

Note

This module always reports changed status because it cannot guarantee idempotence.
Use changed_when to control that in cases where the operation is known to not change state.

Examples 

- name: Generate rotation statement
  ansible.builtin.set_fact:
    rotation_statements = ["ALTER USER \"{{name}}\" WITH PASSWORD '{{password}}';"]

- name: Create / update Static Role with the default mount point
  community.hashi_vault.vault_database_static_role_create:
    url: https://vault:8201
    auth_method: userpass
    username: '{{ user }}'
    password: '{{ passwd }}'
    connection_name: SomeConnection
    role_name: SomeRole
    db_username: '{{ db_username}}'
    rotation_statements: '{{ rotation_statements }}'
  register: response

- name: Display the result of the operation
  ansible.builtin.debug:
    msg: "{{ result }}"

- name: Create / update Static Role with a custom mount point
  community.hashi_vault.vault_database_static_role_create:
    url: https://vault:8201
    auth_method: userpass
    username: '{{ user }}'
    password: '{{ passwd }}'
    engine_mount_point: db1
    connection_name: SomeConnection
    role_name: SomeRole
    db_username: '{{ db_username}}'
    rotation_statements: '{{ rotation_statements }}'
  register: response

- name: Display the result of the operation
  ansible.builtin.debug:
    msg: "{{ result }}"

Authors

Martin Chmielewski (@M4rt1nCh)

community.hashi_vault.vault_database_static_role_create module – Create or update a static role

Synopsis

Requirements

Parameters

Attributes

Notes

Examples