GRANT ZONE OVERRIDE Statement | SQL Data Control Language | Teradata Vantage - GRANT ZONE OVERRIDE - Advanced SQL Engine - Teradata Database

SQL Data Control Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
lmb1556233084626.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1149
lifecycle
previous
Product Category
Teradata® Vantage™ NewSQLEngine

When using Teradata Secure Zones, grants a user who does not belong to any zone the ability to collect dictionary data system-wide and across zones. This privilege applies only to access to DBC tables. It does not include data table access.

Required Privileges

Only user DBC receives this privilege during system initialization and only user DBC can grant the zone override privilege.

Restricted Privileges

You cannot use the WITH GRANT OPTION when granting this privilege.

Syntax

GRANT ZONE OVERRIDE TO user_name [,...] [;]

Syntax Elements

user_name
The name of a user to whom you want to grant DBC table access across all zones to. You can specify up to 25 names in a comma-separated list.

Usage Notes

Users who are not zone users but who have the ZONE OVERRIDE privilege and also have EXECUTE privilege on DBQLAccessMacro can enable and disable query logging on all database objects in a zone.

Users with ZONE OVERRIDE privileges who also have SELECT privileges on V views have system-wide access.