Disabling check of existing tables in SQLDirectory
Is there any way to skip the check of the existing tables in SQLHelper class?
This is because for security reasons (lower-privileged database user). I need to use synonyms (oracle) in place of actual tables and it seems, looking at SQLHelper class, that nuxeo performs a preliminary check by table metadata that doesn't work when the synonyms are used.
Thank you in advance
More information:
I performed a test changed this row in org.nuxeo.ecm.directory.sql.SQLHelper in tableExists method:
ResultSet rs = metaData.getTables(null, schemaName, table.getPhysicalName(), new String[] { “TABLE” }); ResultSet rs = metaData.getTables(null, schemaName, table.getPhysicalName(), new String[] { “TABLE”, “VIEW”, “SYNONYM”});
and I haven't anymore errors