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