16.20 - REVOKE 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, 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



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 ;