REVOKE ZONE OVERRIDE Statement | SQL Data Control Language | Teradata Vantage - 17.05 - REVOKE 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, revokes the privilege to bypass zone restrictions when accessing rows in DBC tables.

Required Privileges

Only user DBC can revoke the ZONE OVERRIDE privilege.

Syntax

REVOKE ZONE OVERRIDE { TO | FROM } user_name [,...] [;]

Syntax Elements

user_name
The names of the users whose access to DBC table data that pertain to all zones you want to revoke. You can specify up to 25 comma-separated names.

Example of Revoking the ZONE OVERRIDE Privilege

This example revokes the ZONE OVERRIDE privilege from a user named Amy_F39674.

REVOKE ZONE OVERRIDE FROM Amy_F39674 ;