Project: QGIS

Version: 3.2.0

Feature: Restrict table list for a Oracle database connection to a preset schema

This change allows a schema to be set in the connection properties for an Oracle database connection. If set, only tables within that schema will be scanned and listed for the connection.

Previously the option existed to restrict the scan to tables which belong to the user, but this option does not support the use case where a connection must access tables from a different user, and the default "scan everything" setting is too expensive (since it often takes multiple minutes to perform, especially when geometryless tables are shown).

This feature was funded by Open Spatial

This feature was developed by Nyall Dawson (North Road)