System Schema

The built-in SYS and SYSADMIN schemas provide metadata tables and procedures against the current VDB.

By default a system schema for ODBC metadata pg_catalog is also exposed - however that should be considered for general use.

Metadata Visibility

The SYS system schema tables and procedures are always visible/accessible.

Unlike Teiid 8.x and prior releases when Data Roles are in use table/views and procedure metadata entries will not be visible if the user is not entitled to use the object. Tables/views/columns require the READ permission and procedures require the EXECUTE permission. All columns of a key must be accessible for the entry to be visible.

Note
If there is any caching of system metadata when data roles are in use, then visibility needs to be considered.

results matching ""

    No results matching ""