On Mon, 27 Jan 2020 at 15:57, Anand Solomon <anand.v.solo...@gmail.com> wrote:
>
> 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 ?

That list of users only has the usernames.
If you loop over them, and that is all the information you have, they
will all have the same password.
Are you sure that is what you want?



> 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
>
>
> --
> You received this message because you are subscribed to the Google Groups 
> "Ansible Project" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to ansible-project+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/ansible-project/d8a7aad1-7272-44b7-b982-3673ec88190b%40googlegroups.com.



-- 
Dick Visser
Trust & Identity Service Operations Manager
GÉANT

-- 
You received this message because you are subscribed to the Google Groups 
"Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ansible-project+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ansible-project/CAL8fbwMnEpb8BxYqiPZ%3DYfW384EULnYur4no8bR7sJwGjetoxw%40mail.gmail.com.

Reply via email to