RELEASE_SYSTEM_TABLES_ACCESS

Enables non-superuser access to all system tables. After you call this function, Vertica ignores the IS_ACCESSIBLE_DURING_LOCKDOWN setting in table SYSTEM_TABLES. To resume enforcement of access restrictions on non-superusers to system tables, call RESTRICT_SYSTEM_TABLES_ACCESS.

This is a meta-function. You must call meta-functions in a top-level SELECT statement.

Behavior type

Syntax

RELEASE_SYSTEM_TABLES_ACCESS()

Privileges

Superuser