Management of quota

[tyskjohan]

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]

Hi, Sorry about the late answer, but yes I think oracle_user is 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]

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.