CREATE ZONE Syntax Elements - Analytics Database - Teradata Vantage

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™
zone_name
Specify a name for the secure zone.
For information about naming database objects, see Teradata Vantage™ - SQL Fundamentals, B035-1141.
ROOT
The zone root is a database or a user on which a secure 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 secure zone, the database or user should not contain any associated objects, users, databases, roles, or profiles.
Root should be an existing user or database. You should create the user or database before you specify the user or database as root.
The user or database that you specify cannot be a guest, creator, or member of another secure zone and cannot contain objects, descendants, roles, profiles, or constraints.
Only the zone creator, owner, and creator of root can have privileges on the root. Other users cannot have privileges on the root. Root cannot have any privileges on other users.
Root cannot be a proxy user.
Root should not be granted with any roles or constraints.
The user should not be logged in while adding the user as a zone root.
Root cannot have a database as default database.
The user or database that you specify cannot have any Access logging or Query logging rules enabled on them or created by them.
database_name
Name of database.
user_name
Name of user.