jmsierra / jmsierra.oracle / 0.2.0 / module / role Manage users/roles in an Oracle database | "added in version" 0.2.0 of jmsierra.oracle" Authors: Mikael Sandström, oravirt@gmail.com, @oravirt, https://github.com/jmsierrajmsierra.oracle.role (0.2.0) — module
Install with ansible-galaxy collection install jmsierra.oracle:==0.2.0
collections: - name: jmsierra.oracle version: 0.2.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 default: present description: - The intended state of the priv (present=added to the user, absent=removed from the user). 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