ansible / ansible.builtin / v2.3.2.0-1 / module / vertica_schema Adds or removes Vertica database schema and roles. | "added in version" 2.0 of ansible.builtin" Authors: Dariusz Owczarek (@dareko) preview | supported by communityansible.builtin.vertica_schema (v2.3.2.0-1) — module
pip
Install with pip install ansible==2.3.2.0.post1
Adds or removes Vertica database schema and, optionally, roles with schema access privileges.
A schema will not be removed until all the objects have been dropped.
In such a situation, if the module tries to remove the schema it will fail and only remove roles created for the schema if they have no dependencies.
- name: creating a new vertica schema vertica_schema: name=schema_name db=db_name state=present
- name: creating a new schema with specific schema owner vertica_schema: name=schema_name owner=dbowner db=db_name state=present
- name: creating a new schema with roles vertica_schema: name=schema_name create_roles=schema_name_all usage_roles=schema_name_ro,schema_name_rw db=db_name state=present
db: default: null description: - Name of the Vertica database. required: false name: description: - Name of the schema to add or remove. required: true port: default: 5433 description: - Vertica cluster port to connect to. required: false owner: default: null description: - Name of the user to set as owner of the schema. required: false state: choices: - present - absent default: present description: - Whether to create C(present), or drop C(absent) a schema. required: false cluster: default: localhost description: - Name of the Vertica cluster. required: false login_user: default: dbadmin description: - The username used to authenticate with. required: false usage_roles: aliases: - usage_role default: null description: - Comma separated list of roles to create and grant usage access to the schema. required: false create_roles: aliases: - create_role default: null description: - Comma separated list of roles to create and grant usage and create access to the schema. required: false login_password: default: null description: - The password used to authenticate with. required: false