ari_stark.ansible_oracle_modules.oracle_role (1.2.1) — module

Install collection

Install with ansible-galaxy collection install ari_stark.ansible_oracle_modules:==1.2.1

Add to requirements.yml

  collections:
    - name: ari_stark.ansible_oracle_modules
      version: 1.2.1

Description

This module manage Oracle role objects.

It handles creation and deletion of roles.

It doesn't support changing password. There's no hint to know a password was changed, so no change is made.

Requirements

• Python module cx_Oracle
• Oracle basic tools.

Usage examples

Scanned by Steampunk Spotter

• Success
  Steampunk Spotter scan finished with no errors, warnings or hints.

- name: Ensure role exists
  oracle_role:
    hostname: remote-db-server
    service_name: orcl
    user: system
    password: manager
    role: myrole
    state: present

Scanned by Steampunk Spotter

• Success
  Steampunk Spotter scan finished with no errors, warnings or hints.

- name: Set the password "bar" to a role
  oracle_role:
    hostname: remote-db-server
    service_name: orcl
    user: system
    password: manager
    role: myrole
    state: present
    identified_method: password
    identified_value: bar

Scanned by Steampunk Spotter

• Success
  Steampunk Spotter scan finished with no errors, warnings or hints.

- name: Ensure role doesn't exist
  oracle_role:
    hostname: localhost
    service_name: orcl
    user: system
    password: manager
    role: myrole
    state: absent

Inputs

    
mode:
    choices:
    - normal
    - sysdba
    default: normal
    description:
    - This option is the database administration privileges.
    type: str

port:
    default: 1521
    description:
    - Specify the listening port on the database server.
    type: int

role:
    description:
    - The name of the role to create/alter/drop.
    - The name is changed in upper case.
    required: true
    type: str

state:
    choices:
    - present
    - absent
    default: present
    description:
    - Specify the state of the role.
    type: str

hostname:
    default: localhost
    description:
    - Specify the host name or IP address of the database server computer.
    type: str

password:
    description:
    - Set the password to use to connect the database server.
    - Must not be set if using Oracle wallet.
    type: str

username:
    aliases:
    - user
    description:
    - Set the login to use to connect the database server.
    - Must not be set if using Oracle wallet.
    type: str

oracle_home:
    description:
    - Define the directory into which all Oracle software is installed.
    - Define ORACLE_HOME environment variable if set.
    type: str

service_name:
    description:
    - Specify the service name of the database you want to access.
    required: true
    type: str

identified_value:
    description:
    - This is the value to use using authentication by password or using a package.
    - Required if I(identified_method=password) or I(identified_method=application).
    type: str

identified_method:
    choices:
    - none
    - password
    - application
    - external
    - global
    default: none
    description:
    - Specify the authentication method to use to connect with role.
    type: str

Outputs

ddls:
  description: Ordered list of DDL requests executed during module execution.
  elements: str
  returned: always
  type: list