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/166a09c3-d4ae-4f36-b303-b15c80998a04%40googlegroups.com.
