REVOKE ZONE Statement | SQL Data Control Language | Teradata Vantage - 17.05 - REVOKE ZONE - 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 zone access from zone guests. Zone guests are users or roles that do not belong to the zone but have previously been granted zone access.

Required Privileges

Only the creator of the zone can revoke zone access from a zone guest.

Syntax

REVOKE ZONE zone_name [...]
  { TO | FROM }
  { { user_name | role_name } [,...] | PUBLIC } [;]

Syntax Elements

zone_name
The name of the zone.
The zone must already exist.
user_name
role_name
The names of the zone guests that you want to revoke zone access from. You can specify up to 25 names in a comma-separated list.

Example of Revoking Zone Privileges

This example revokes the privileges from a zone guest named guest_jim01.

REVOKE ZONE widgets_inc_zone FROM guest_jim01 ;