ibre5041.ansible_oracle_modules.oracle_grant (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 grant/privileges in an Oracle database

Handles role/sys privileges at the moment.

It is possible to add object privileges as well, but they are not considered when removing privs at the moment.

See connection parameters for oracle_ping

Requirements

• cx_Oracle

Inputs

    
grant:
    default: null
    description: The privileges granted to the new schema. Can be a string or a list
    required: false

state:
    choices:
    - present
    - absent
    - REMOVEALL
    default: present
    description:
    - The intended state of the priv (present=added to the user, absent=removed from the
      user).
    - REMOVEALL will remove ALL role/sys privileges

grantee:
    default: null
    description: The schema that should get grant added/removed
    required: false

grant_mode:
    choices:
    - exact
    - append
    default: append
    description:
    - Should the list of grant be enforced, or just appended to
    - 'exact: Whatever is in the list of grant will be enforced, i.e grant/privileges
      will be removed if they are not in the list'
    - 'append: Grant/privileges are just appended, nothing is removed'

object_privs:
    default: null
    description:
    - The privileges granted to specific objects
    - 'format: ''priv1,priv2,priv3:owner.object_name'''
    - e.g.
    - select,update,insert,delete:sys.dba_tablespaces
    - select:sys.v_$session
    required: false