REVOKE ZONE Statement | SQL Data Control Language | Teradata Vantage - REVOKE ZONE - Advanced SQL Engine - Teradata Database

SQL Data Control Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
lmb1556233084626.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1149
lifecycle
previous
Product Category
Teradata® Vantage™ NewSQLEngine

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 ;