This works now. Thanks.
On Monday, January 27, 2020 at 11:03:57 AM UTC-5, Dick Visser wrote:
>
> If you supply the list as:
>
> vars:
> schemaname:
> - user1
> - user2
> - user3
>
> then it's as easy as:
>
> loop: "{{ schemaname }}"
>
>
> If you get that comma delimited string from somewhere else (which I
> asked but got no response to), then you'd have to manually split and
> trim:
>
> loop: "{{ schemaname.split(',') | map('trim') | list }}"
>
>
>
>
>
>
> On Mon, 27 Jan 2020 at 16:53, Anand Solomon <[email protected]
> <javascript:>> wrote:
> >
> > Yes, All I want to create is the user from the list (vars). This will be
> hard coded value from the vars and the password will be the same for all
> the users.
> >
> >
> >
> > On Monday, January 27, 2020 at 10:34:25 AM UTC-5, Dick Visser wrote:
> >>
> >> On Mon, 27 Jan 2020 at 15:57, Anand Solomon <[email protected]>
> 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 [email protected].
> >> > 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 [email protected] <javascript:>.
> > To view this discussion on the web visit
> https://groups.google.com/d/msgid/ansible-project/a0d681bc-20c1-41f1-bc77-5e9903acf8b3%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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/c2501668-38bd-45be-953a-8a9ead5ff581%40googlegroups.com.
