community.general.vertica_role (0.1.1) — module

Install collection

Install with ansible-galaxy collection install community.general:==0.1.1

Add to requirements.yml

  collections:
    - name: community.general
      version: 0.1.1

Description

Adds or removes Vertica database role and, optionally, assign other roles.

Requirements

• unixODBC
• pyodbc

Usage examples

Scanned by Steampunk Spotter

• Success
  Steampunk Spotter scan finished with no errors, warnings or hints.

- name: creating a new vertica role
  vertica_role: name=role_name db=db_name state=present

Scanned by Steampunk Spotter

• Success
  Steampunk Spotter scan finished with no errors, warnings or hints.

- name: creating a new vertica role with other role assigned
  vertica_role: name=role_name assigned_role=other_role_name state=present

Inputs

    
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.