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

Teradata Vantageā„¢ - SQL Data Control Language

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1149-170K

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.