Just this made the trick. Thanks very much
roles: "{{item}}"
quiet: false
environment: "{{oracle_env}}"
register: user_privs
with_items : "{{query_result.msg}}"
On Thursday, January 30, 2020 at 3:20:38 PM UTC-5, Anand Solomon wrote:
>
> The result I get from the query_result is something like
> this [["TESTDBA"], ["TESTDBA2"]]
>
> I want to know how to pass this variable removing the square brackets and
> the *roles* in the task
>
> On Thursday, January 30, 2020 at 2:52:43 PM UTC-5, Anand Solomon wrote:
>>
>> Hi,
>> Thanks for your help. I may be asking a simple question. I am new to
>> ansible, so trying to learn.
>>
>> This is what I need to understand.
>>
>> 1. Run the below
>> sql: select grantee FROM DBA_SYS_PRIVS where PRIVILEGE='INSERT
>> ANY TABLE' and grantee not like 'SYS' and grantee != 'WMSYS' and grantee !=
>> 'DBA' and grantee != 'IMP_FULL_DATABASE';
>> register: query_result
>>
>> The query result will be the users in the DB has DBA_SYS_PRIVS and it can
>> be more than one.I want to iterate the below task passing the username
>> dynamically.
>>
>> 2. The query_result have to be iterated in the below
>>
>> - 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:
>> - INSERT ANY TABLE
>> state: absent
>> * roles: "{{ query_result }}"*
>> quiet: false
>> environment: "{{oracle_env}}"
>> register: user_privs
>> delegate_to: localhost
>>
>> On Thursday, January 30, 2020 at 9:02:02 AM UTC-5, Vladimir Botka wrote:
>>>
>>> On Thu, 30 Jan 2020 05:38:17 -0800 (PST)
>>> Anand Solomon <[email protected]> wrote:
>>>
>>> > - name: Display the query results
>>> > debug:
>>> > msg: "{{ query_result }}"
>>> >
>>> > and I get [["TESTDBA"]], I want the value to be TESTDBA.
>>>
>>> The value you're looking for is the first item of the first list
>>>
>>> - debug:
>>> msg: "{{ query_result.0.0 }}"
>>>
>>> gives
>>>
>>> "msg": "TESTDBA"
>>>
>>> HTH,
>>>
>>> -vlado
>>>
>>
--
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/697bb7ee-8d1c-4068-bde4-758d945b4b21%40googlegroups.com.
