search

oravirt / ansible-oracle-modules

Oracle modules for Ansible
MIT License
214 stars 160 forks source link

Management of quota #114

Open tyskjohan opened 5 years ago

tyskjohan commented 5 years ago

I am thinking to add possibility to manage quotas on tablespaces. I am looking for input on whether I should do this in oracle_user, oracle_tablespace or create a new oracle_quota module.

My current thinking is to add it to oracle_user such as:

oracle_user:
  hostname: localhost
  service_name: orcl
  user: system
  password: manager
  schema: myschema
  schema_password: mypass
  default_tablespace: test
  state: present
  grants: dba
  quota:
  - tablespace1:unlimited
  - tablespace2:10M

The main disadvantage is that quota revocation can't be easily handled here, but that is not something I need. I could imagine a quota_mode but I'll leave that to someone else :-)

oravirt commented 5 years ago

Hi, Sorry about the late answer, but yes I think oracle_useris the correct place for this and I also like the way the quota is defined. Also, I really appreciate you adding this functionality (should you choose to do so ;-) )

Rendanic commented 4 years ago

Hi, I created a solution for this issue today. The whole design of modify_user is impacted by this enhacement... For time reasons I could not perform the refactoring.