System schema

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

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 and accessible.

When data roles are in use, users can view only the tables, views, and procedure metadata entries that they have permissions to access. All columns of a key must be accessible for an entry to be visible.

Note
To make all metadata visible to any authenticated user, set the environment/system property org.teiid.metadataRequiresPermission to false.
Note
If you use data roles, visibility of entries can be affected by the caching of system metadata.

results matching ""

    No results matching ""