ibre5041.ansible_oracle_modules.oracle_user (3.2.0) — module

Install collection

Install with ansible-galaxy collection install ibre5041.ansible_oracle_modules:==3.2.0

Add to requirements.yml

  collections:
    - name: ibre5041.ansible_oracle_modules
      version: 3.2.0

Description

Manage users/schemas in an Oracle database

Can be run locally on the control machine or on a remote host

See connection parameters for oracle_ping

Requirements

• cx_Oracle
• pbkdf2

Inputs

    
state:
    choices:
    - present
    - absent
    default: present
    description: Whether the user should exist. Absent removes the user (cascade)
    required: false

locked:
    description:
    - Lock or unlock account.
    - If not specified for a new user, Oracle default will be used.
    required: false
    type: bool

schema:
    default: None
    description: The schema that you want to manage
    required: false

expired:
    description:
    - Expire password
    - If not specified for a new user, Oracle default will be used.
    required: false
    type: bool

profile:
    default: None
    description: The profile for the user
    required: false

schema_password:
    default: null
    description: The password for the new schema. i.e '..identified by password'
    required: false

default_tablespace:
    default: None
    description: The default tablespace for the new schema. The tablespace must exist
    required: false

authentication_type:
    choices:
    - password
    - external
    - global
    - none
    default: password
    description: The type of authentication for the user
    required: false

schema_password_hash:
    default: None
    description: The password hash for the new schema. i.e '..identified by values "XXXXXXX"'
    required: false

default_temp_tablespace:
    default: None
    description: The default tablespace for the new schema. The tablespace must exist
    required: false