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

0 votes

1 answers

1635 views

ANSWER



You could change all your directory/vocabulary configurations to have <createTablePolicy>never</createTablePolicy> but that's a lot of directories to track down. Otherwise NXP-19635 would solve this but it's not yet scheduled to be implemented.

0 votes