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] > <javascript:>> 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] <javascript:>. > > 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/a0d681bc-20c1-41f1-bc77-5e9903acf8b3%40googlegroups.com.
