16.20 - GRANT ZONE OVERRIDE - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SQL Data Control Language

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1149-162K

Purpose

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



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.