When we configure a Oracle database in Mendix using the administrator account i.e SYS as SYSBDA , It works fine and mendix creates all the entities into The oracle database (tables) etch. However , when we configure a specific user schema “XYX” it does not work, Besides we have tried granting the DBA privilage to the schema “XYX” still it dosent seem to work.
This is surely a permission Issue and we would like to know what are the previlages which need to be granted to the schema so that it can be configured successfully with mendix application.
We have currently granted the below provilages
connect, resource, create view, create procedure, create trigger along with DBA Privilage, However it still dosent work.