Hi,
I want to create users in the database using Ansible. I need ansible to run the task (creating user) for all the users mentioned in the vars: schemaname. How do I do that in loop ?
var:
schemaname: user1, user2, user3
tasks:
- name: This playbook will create the user.
oracle_user:
oracle_home: /home/ansible/instantclient_12_2
user: “{{user}}”
password: “{{password}}”
service_name: “{{sname}}”
port: “{{prt}}”
hostname: “{{hostname}}”
schema: “{{schemaname}}”
schema_password:
default_tablespace: USERS
state: present
update_password: on_create
grants: “DBA”
environment: “{{oracle_env}}”
register: user_create
delegate_to: localhost