ari_stark.ansible_oracle_modules.oracle_quota (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 manages Oracle quota for users.

It can ensure a single quota is present/absent.

It can ensure a list of quotas matches the quotas in database.

It can ensure a user has no quota.

Username and tablespace name are case insensitive.

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: define unlimited quota to user on a tablespace
  oracle_quota:
    service_name: "xepdb1"
    username: "sys"
    password: "manager"
    mode: "sysdba"
    schema_name: "foo_user"
    tablespace: "foo_ts"
    state: "present"

Scanned by Steampunk Spotter

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

- name: define quota to user on a tablespace
  oracle_quota:
    service_name: "xepdb1"
    username: "sys"
    password: "manager"
    mode: "sysdba"
    schema_name: "foo_user"
    tablespace: "foo_ts"
    size: "5M"
    state: "present"

Scanned by Steampunk Spotter

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

- name: ensure quota for a user are defined (add, remove or change quota)
  oracle_quota:
    service_name: "xepdb1"
    username: "sys"
    password: "manager"
    mode: "sysdba"
    schema_name: "foo_user"
    tablespaces:
      - "foo_ts"
      - "bar_ts"
    size: "5M"
    state: "present"

Scanned by Steampunk Spotter

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

- name: ensure quota is absent for user on a tablespace
  oracle_quota:
    service_name: "xepdb1"
    username: "sys"
    password: "manager"
    mode: "sysdba"
    schema_name: "foo_user"
    tablespace: "foo_ts"
    state: "absent"

Scanned by Steampunk Spotter

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

- name: ensure a user has no quota
  oracle_quota:
    service_name: "xepdb1"
    username: "sys"
    password: "manager"
    mode: "sysdba"
    schema_name: "foo_user"
    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

size:
    default: unlimited
    description:
    - Specify the size of the quota.
    type: str

state:
    choices:
    - absent
    - present
    default: present
    description:
    - Specify the state of the quota.
    - If I(state=absent) and no I(tablespace) nor I(tablespaces) are defined, all quotas
      will be removed.
    - If I(state=absent) with I(tablespace) or I(tablespaces), quotas will be remove for
      these tablepaces.
    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

tablespace:
    description:
    - Specify the tablespace name where quota must be defined.
    - I(tablespace) and I(tablespaces) are mutually exclusive.
    - When defined, module ensures the defined quota is absent/present with defined size.
    - This value is case insensitive.
    required: false
    type: str

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

schema_name:
    aliases:
    - name
    description:
    - Name of the user to manage.
    required: true
    type: str

tablespaces:
    description:
    - Specify the list of tablespaces names where quota must be defined.
    - I(tablespace) and I(tablespaces) are mutually exclusive.
    - When defined and I(state=present), modules ensures the quotas are defined exactly,
      removing or adding quotas.
    - When defined and I(state=absent), modules ensures the quotas are absent for these
      tablespaces.
    - Values are case insensitive.
    elements: str
    required: false
    type: list

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