CREATE ZONE SQL Statement | Teradata Vantage - CREATE ZONE - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

Defines a Teradata Secure Zone. You can also specify an existing database or user as the zone root.

A secure zone is an area which restricts unauthorized outside users from accessing data and objects within the zone.

The zone root is a database or a user on which a zone is created. You create a secure zone and associate a database or a user as the root. Before assigning the database or user as the root of a zone, the database or user should not contain any objects, users, databases, roles, or profiles.

For information on adding guests to a zone, see GRANT ZONE in Teradata Vantage™ - SQL Data Control Language, B035-1149

For information on assigning a primary Database Administrator to a zone, see “Implementing Teradata Secure Zones” in Teradata Vantage™ - Advanced SQL Engine Security Administration, B035-1100

Required Privileges

To create a secure zone, you must have the CREATE ZONE privilege.

To define a user as a root, the zone creator must have DROP USER privilege on the user that becomes a root.

To define a database as root, the zone creator must have CREATE USER privilege on the database that becomes a root.