ansible / ansible.builtin / v2.9.27 / module / vertica_role Adds or removes Vertica database roles and assigns roles to them. | "added in version" 2.0 of ansible.builtin" Authors: Dariusz Owczarek (@dareko) preview | supported by communityansible.builtin.vertica_role (v2.9.27) — module
pip
Install with pip install ansible==2.9.27
Adds or removes Vertica database role and, optionally, assign other roles.
- name: creating a new vertica role vertica_role: name=role_name db=db_name state=present
- name: creating a new vertica role with other role assigned vertica_role: name=role_name assigned_role=other_role_name state=present
db: description: - Name of the Vertica database. name: description: - Name of the role to add or remove. required: true port: default: 5433 description: - Vertica cluster port to connect to. state: choices: - present - absent default: present description: - Whether to create C(present), drop C(absent) or lock C(locked) a role. cluster: default: localhost description: - Name of the Vertica cluster. login_user: default: dbadmin description: - The username used to authenticate with. assigned_roles: aliases: - assigned_role description: - Comma separated list of roles to assign to the role. login_password: description: - The password used to authenticate with.