Simple Loop

[anandsolomon]

Hi, How do I pass the variable using loop from a file to sql and privs ?

  vars_files:
    - /home/ansible/protect/vault-pass.yml
    - /home/ansible/protect/RevokePrivs.yml

  tasks:
    - name: Script will query users
      oracle_sql:
        username: "{{user}}"
        password: "{{password}}"
        service_name: "{{sname}}"
        port: "{{prt}}"
        hostname: "{{hostname}}"
        sql: "{{sqlq}}"
      environment: "{{oracle_env}}"
      register: query_result
      connection: local

    - name: This playbook will grant or revoke privilges in the user.
      oracle_privs:
        user: "{{user}}"
        password: "{{password}}"
        service_name: "{{sname}}"
        port: "{{prt}}"
        hostname: "{{hostname}}"
        privs: "{{item.1}}"
        state: absent
        roles: "{{item}}"
        quiet: false
      environment: "{{oracle_env}}"
      register: user_privs
      with_items : "{{query_result.msg}}"
      delegate_to: localhost

RevokePrivs.yml

  compliance:
    - name: Check 1
      sqlquery: query1;
      privs: INSERT ANY TABLE

    - name: Check 2
      sqlquery:  query2;
      privs: CREATE ANY TABLE