<commit_before>---
# tasks file fororadb-manage-users

- name: Manage users (db/cdb)
  oracle_user:
    hostname={{ ansible_hostname }}
    port={{ listener_port_template }}
    service_name={{ db_service_name }}
    user={{ db_user }}
    password={{ <PASSWORD> }}
    mode="{{ db_mode }}"
    schema={{ item.1.schema }}
    schema_password={{ <PASSWORD> }}
    schema_password_hash={{ user_cdb_password_hash | default(omit) }}
    profile={{ item.1.profile | default (omit) }}
    state={{ item.1.state }}
    default_tablespace={{ item.1.default_tablespace | default (omit) }}
    default_temp_tablespace={{ item.1.default_temp_tablespace | default (omit) }}
    container={{ item.1.container | default(omit) }}
    update_password={{ item.1.update_password | default('on_create') }}
    authentication_type={{ item.1.authentication_type | default(omit) }}
    grants={{ item.1.grants | default (omit) }}
  with_subelements:
    - "{{ oracle_databases }}"
    - users
    - flags:
      skip_missing: true
  environment: "{{ oracle_env }}"
  when:
    - oracle_databases is defined
    - item.0.state | lower == 'present'
    - item.1 is defined
  run_once: "{{ configure_cluster }}"
  become_user: "{{ oracle_user }}"
  loop_control:
    label: "port: {{ listener_port_template }} service: {{ db_service_name }} schema: {{ item.1.schema }} state:{{ item.1.state }}"
  tags: users

- name: Manage users (pdb)
  oracle_user:
    hostname={{ ansible_hostname }}
    port={{ listener_port_template }}
    service_name={{ item.0.pdb_name }}
    user={{ db_user }}
    password={{ <PASSWORD>_pdb }}
    mode="{{ db_mode }}"
    schema={{ item.1.schema }}
    schema_password={{ <PASSWORD>pdb_password }}
    schema_password_hash={{ user_pdb_password_hash | default(omit) }}
    profile={{ item.1.profile | default (omit) }}
    state={{ item.1.state }}
    default_tablespace={{ item.1.default_tablespace | default (omit) }}
    default_temp_tablespace={{ item.1.default_temp_tablespace | default (omit) }}
    update_password={{ item.1.update_password | default('on_create') }}
    authentication_type={{ item.1.authentication_type | default(omit) }}
    grants={{ item.1.grants | default (omit) }}
  with_subelements:
    - "{{ oracle_pdbs }}"
    - users
    - flags:
      skip_missing: true
  environment: "{{ oracle_env }}"
  when:
    - oracle_pdbs is defined
    - item.0.state | lower == 'present'
    - item.1 is defined
  run_once: "{{ configure_cluster }}"
  become_user: "{{ oracle_user }}"
  loop_control:
    label: "port: {{ listener_port_template }} service: {{ item.0.pdb_name }} schema: {{ item.1.schema }} state:{{ item.1.state }}"
  tags: users
<commit_msg>- added support to interpret password as hash instead of plaintext in   dbpasswords by setting users[*].password_is_hash=true - revert to module defaults for update_password parameter<commit_after>---
# tasks file fororadb-manage-users

- name: Manage users (db/cdb)
  oracle_user:
    hostname={{ ansible_hostname }}
    port={{ listener_port_template }}
    service_name={{ db_service_name }}
    user={{ db_user }}
    password={{ <PASSWORD> }}
    mode="{{ db_mode }}"
    schema={{ item.1.schema }}
    schema_password={{ item.1.password_is_hash | default(false) | ternary(omit,user_cdb_password) }}
    schema_password_hash={{ item.1.password_is_hash | default(false) | ternary(user_cdb_password,omit) }}
    profile={{ item.1.profile | default (omit) }}
    state={{ item.1.state }}
    default_tablespace={{ item.1.default_tablespace | default (omit) }}
    default_temp_tablespace={{ item.1.default_temp_tablespace | default (omit) }}
    container={{ item.1.container | default(omit) }}
    update_password={{ item.1.update_password | default(omit) }}
    authentication_type={{ item.1.authentication_type | default(omit) }}
    grants={{ item.1.grants | default (omit) }}
  with_subelements:
    - "{{ oracle_databases }}"
    - users
    - flags:
      skip_missing: true
  environment: "{{ oracle_env }}"
  when:
    - oracle_databases is defined
    - item.0.state | lower == 'present'
    - item.1 is defined
  run_once: "{{ configure_cluster }}"
  become_user: "{{ oracle_user }}"
  loop_control:
    label: "port: {{ listener_port_template }} service: {{ db_service_name }} schema: {{ item.1.schema }} state:{{ item.1.state }}"
  tags: users

- name: Manage users (pdb)
  oracle_user:
    hostname={{ ansible_hostname }}
    port={{ listener_port_template }}
    service_name={{ item.0.pdb_name }}
    user={{ db_user }}
    password={{ <PASSWORD> }}
    mode="{{ db_mode }}"
    schema={{ item.1.schema }}
    schema_password={{ item.1.password_is_hash | default(false) | ternary(omit,user_pdb_password) }}
    schema_password_hash={{ item.1.password_is_hash | default(false) | ternary(user_pdb_password,omit) }}
    profile={{ item.1.profile | default (omit) }}
    state={{ item.1.state }}
    default_tablespace={{ item.1.default_tablespace | default (omit) }}
    default_temp_tablespace={{ item.1.default_temp_tablespace | default (omit) }}
    update_password={{ item.1.update_password | default(omit) }}
    authentication_type={{ item.1.authentication_type | default(omit) }}
    grants={{ item.1.grants | default (omit) }}
  with_subelements:
    - "{{ oracle_pdbs }}"
    - users
    - flags:
      skip_missing: true
  environment: "{{ oracle_env }}"
  when:
    - oracle_pdbs is defined
    - item.0.state | lower == 'present'
    - item.1 is defined
  run_once: "{{ configure_cluster }}"
  become_user: "{{ oracle_user }}"
  loop_control:
    label: "port: {{ listener_port_template }} service: {{ item.0.pdb_name }} schema: {{ item.1.schema }} state:{{ item.1.state }}"
  tags: users

{'fraction_non_alphanumeric': 0.15688685874912156, 'fraction_numerical': 0.010189739985945186, 'mean_word_length': 3.7560568086883874, 'pattern_counts': {'":': 0, '<': 9, '<?xml version=': 0, '>': 9, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5512224', 'n_tokens_mistral': 1888, 'n_tokens_neox': 1906, 'n_words': 370}