opitzconsulting / opitzconsulting.ansible_oracle / 4.7.0 / module / oracle_role Manage users/roles in an Oracle database | "added in version" 1.9.1 of opitzconsulting.ansible_oracle" Authors: Mikael Sandström, oravirt@gmail.com, @oravirtopitzconsulting.ansible_oracle.oracle_role (4.7.0) — module
Install with ansible-galaxy collection install opitzconsulting.ansible_oracle:==4.7.0
collections: - name: opitzconsulting.ansible_oracle version: 4.7.0
Manage grants/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.
mode: choices: - normal - sysdba default: normal description: The mode with which to connect to the database required: true port: default: 1521 description: The listener port number on the host required: false role: default: null description: The role that should get grants added/removed required: false user: description: The Oracle user name to connect to the database required: true 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 ' grants: default: null description: The privileges granted to the new role. Can be a string or a list required: false hostname: default: localhost description: The Oracle database host required: false password: description: The Oracle user password for 'user' required: true service_name: description: The database service name to connect to required: true