ansible / ansible.builtin / v2.4.3.0-1 / module / vertica_user Adds or removes Vertica database users and assigns roles. | "added in version" 2.0 of ansible.builtin" Authors: Dariusz Owczarek (@dareko) preview | supported by communityansible.builtin.vertica_user (v2.4.3.0-1) — module
pip
Install with pip install ansible==2.4.3.0.post1
Adds or removes Vertica database user and, optionally, assigns roles.
A user will not be removed until all the dependencies have been dropped.
In such a situation, if the module tries to remove the user it will fail and only remove roles granted to the user.
- name: creating a new vertica user with password vertica_user: name=user_name password=md5<encrypted_password> db=db_name state=present
- name: creating a new vertica user authenticated via ldap with roles assigned vertica_user: name=user_name ldap=true db=db_name roles=schema_name_ro state=present
db: default: null description: - Name of the Vertica database. required: false ldap: default: null description: - Set to true if users are authenticated via LDAP. - The user will be created with password expired and set to I($ldap$). required: false name: description: - Name of the user to add or remove. required: true port: default: 5433 description: - Vertica cluster port to connect to. required: false roles: aliases: - role default: null description: - Comma separated list of roles to assign to the user. required: false state: choices: - present - absent - locked default: present description: - Whether to create C(present), drop C(absent) or lock C(locked) a user. required: false cluster: default: localhost description: - Name of the Vertica cluster. required: false expired: default: null description: - Sets the user's password expiration. required: false profile: default: null description: - Sets the user's profile. required: false password: default: null description: - The user's password encrypted by the MD5 algorithm. - The password must be generated with the format C("md5" + md5[password + username]), resulting in a total of 35 characters. An easy way to do this is by querying the Vertica database with select 'md5'||md5('<user_password><user_name>'). required: false login_user: default: dbadmin description: - The username used to authenticate with. required: false resource_pool: default: null description: - Sets the user's resource pool. required: false login_password: default: null description: - The password used to authenticate with. required: false