jmsierra.oracle.user (0.2.0) — module

Install collection

Install with ansible-galaxy collection install jmsierra.oracle:==0.2.0

Add to requirements.yml

  collections:
    - name: jmsierra.oracle
      version: 0.2.0

Description

Manage users/schemas in an Oracle database

Can be run locally on the controlmachine or on a remote host

Requirements

• cx_Oracle

Inputs

    
mode:
    choices:
    - normal
    - sysdba
    default: normal
    description:
    - The mode with which to connect to the database
    required: false

port:
    default: 1521
    description:
    - The listener port number on the host
    required: false

user:
    description:
    - The Oracle user name to connect to the database
    required: false

state:
    choices:
    - present
    - absent
    - locked
    - unlocked
    default: present
    description:
    - Whether the user should exist. Absent removes the user, locked/unlocked locks or
      unlocks the user
    required: false

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

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

hostname:
    default: localhost
    description:
    - The Oracle database host
    required: false

password:
    description:
    - The Oracle user password for 'user'
    required: false

service_name:
    description:
    - The database service name to connect to
    required: true

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

update_password:
    choices:
    - always
    - on_create
    default: always
    description:
    - always will update passwords if they differ. on_create will only set the password
      for newly created users.
    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
    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