community.general.vertica_role – Adds or removes Vertica database roles and assigns roles to them.
community.general.vertica_role – Adds or removes Vertica database roles and assigns roles to them.
Note
This plugin is part of the community.general collection (version 2.0.1).
To install it use: ansible-galaxy collection install community.general
.
To use it in a playbook, specify: community.general.vertica_role
.
Synopsis
- Adds or removes Vertica database role and, optionally, assign other roles.
Requirements
The below requirements are needed on the host that executes this module.
- unixODBC
- pyodbc
Parameters
Parameter | Choices/Defaults | Comments |
---|---|---|
assigned_roles string |
Comma separated list of roles to assign to the role.
| |
cluster string |
Default: "localhost" |
Name of the Vertica cluster. |
db string |
Name of the Vertica database. | |
login_password string |
The password used to authenticate with. | |
login_user string |
Default: "dbadmin" |
The username used to authenticate with. |
name string / required |
Name of the role to add or remove. | |
port string |
Default: 5433 |
Vertica cluster port to connect to. |
state string |
|
Whether to create |
Notes
Note
- The default authentication assumes that you are either logging in as or sudo’ing to the
dbadmin
account on the host. - This module uses
pyodbc
, a Python ODBC database adapter. You must ensure thatunixODBC
andpyodbc
is installed on the host and properly configured. - Configuring
unixODBC
for Vertica requiresDriver = /opt/vertica/lib64/libverticaodbc.so
to be added to theVertica
section of either/etc/odbcinst.ini
or$HOME/.odbcinst.ini
and bothErrorMessagesPath = /opt/vertica/lib64
andDriverManagerEncoding = UTF-16
to be added to theDriver
section of either/etc/vertica.ini
or$HOME/.vertica.ini
.
Examples
- name: Creating a new vertica role
community.general.vertica_role: name=role_name db=db_name state=present
- name: Creating a new vertica role with other role assigned
community.general.vertica_role: name=role_name assigned_role=other_role_name state=present
Authors
- Dariusz Owczarek (@dareko)
© 2012–2018 Michael DeHaan
© 2018–2021 Red Hat, Inc.
Licensed under the GNU General Public License version 3.
https://docs.ansible.com/ansible/2.11/collections/community/general/vertica_role_module.html