rendanic.ansible_oracle.oracle_user (4.0.0) — module

Install collection

Install with ansible-galaxy collection install rendanic.ansible_oracle:==4.0.0

Add to requirements.yml

  collections:
    - name: rendanic.ansible_oracle
      version: 4.0.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

grants:
    default: None
    description: The privileges granted to the new schema
    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