We have Database Vault enabled and therefore SYS has no privileges on realm objects. But this means that some automated jobs, such as PMO_DEFERRED_GIDX_MAINT, fail because ALTER INDEX fails.
I have all objects from application schemas in realm to stop manipulation of objects as well as restricting access to data and do not really want to change this due to the huge additional amount of maintenance required if we have to manually add objects every time schemas are updated.
Is there a solution to this?
And btw could we have a dedicated space for Database Vault since it's quite a large subject?